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

2 votes353 views2 answers
Run mysql command from bash
SQL
0 vote361 views1 answer
Sql tablo sp
SQL
0 vote342 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote386 views1 answer
Altrer name column postgres
SQL
1 vote355 views1 answer
Error code 1175 mysql fix
SQL
0 vote343 views1 answer
Sql server order by nulls last
SQL
0 vote372 views1 answer
Sql date between one week
SQL
1 vote372 views1 answer
Myql find duplicates
SQL
0 vote347 views1 answer
Find largest table in mysql database
SQL
3 votes354 views2 answers
Mysql import gz
SQL