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 vote187 views2 answers
Replace text in sql
SQL
1 vote175 views1 answer
Funzioni plsql
SQL
0 vote185 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote197 views1 answer
Sql bild in function
SQL
0 vote176 views1 answer
Check index sql server
SQL
0 vote199 views1 answer
Sql query to find duplicate email address
SQL
-1 vote192 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
1 vote200 views1 answer
PL SQL MODIFY COLUMN NME
SQL
2 votes232 views1 answer
Tcl in sql
SQL
0 vote195 views1 answer
Compare if is null sql
SQL