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

1 vote124 views1 answer
Mysql select row max date
SQL
0 vote122 views1 answer
Mysql cli output to a file
SQL
2 votes149 views1 answer
Postgresql group by month and year
SQL
0 vote120 views1 answer
Mysql workbench format date
SQL
0 vote115 views1 answer
How to check even or odd in sql
SQL
2 votes119 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote125 views1 answer
Insert set mysql
SQL
0 vote99 views1 answer
Mql5 list all available symbols
SQL
0 vote117 views1 answer
Str_to_date sql server
SQL
0 vote124 views1 answer
Mysql error 1251
SQL