Oracle select

SELECT expressions
FROM tables
[WHERE conditions];

Source: techonthenet.com

SELECT INTO Oracle

DECLARE
  r_customer customers%ROWTYPE;
BEGIN
  -- get the information of the customer 100
  SELECT * INTO r_customer
  FROM customers
  WHERE customer_id = 100;
  -- show the customer info
  dbms_output.put_line( r_customer.name || ', website: ' || r_customer.website );
END;
Code language: SQL (Structured Query Language) (sql)

Source: oracletutorial.com

Similar codes

0 vote314 views1 answer
Call function in query sql server
SQL
0 vote347 views1 answer
Will graphql replace sql
SQL
5 votes347 views4 answers
Restart the psql server windows
SQL
0 vote367 views1 answer
Insert using condition postgres
SQL
9 votes355 views4 answers
Mysql set id auto increment
SQL
0 vote348 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote347 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote368 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote361 views1 answer
Joomla execute raw sql
SQL
52 votes571 views6 answers
Rename column sql
SQL