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 vote305 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote290 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote278 views1 answer
Mysql workbench procedure
SQL
2 votes293 views1 answer
Mysql clear screen
SQL
0 vote322 views1 answer
Add user mysql wordpress
SQL
0 vote272 views2 answers
How to find max and min salary in sql
SQL
0 vote292 views1 answer
Sql select random procentage from rows
SQL
-1 vote293 views1 answer
Mysql case when multiple conditions
SQL
0 vote258 views2 answers
Avg() sql
SQL
2 votes313 views1 answer
Where clause for child record apex
SQL