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

7 votes243 views2 answers
Mysql default value
SQL
28 votes146 views6 answers
Sql update
SQL
4 votes151 views1 answer
Oracle show errors
SQL
0 vote168 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
15 votes151 views2 answers
How to drop database name in postgresql
SQL
1 vote146 views1 answer
Generate random data postgresql
SQL
-1 vote174 views1 answer
Partial search in sql
SQL
1 vote139 views1 answer
Deleting database in sql
SQL
-1 vote155 views2 answers
Full join sql
SQL
1 vote165 views1 answer
Apex select list ORA-20999
SQL