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

8 votes252 views1 answer
Oracle all_source package body
SQL
2 votes254 views2 answers
How to DROP a table in mysql
SQL
0 vote231 views1 answer
Alter session set nls_language french
SQL
3 votes252 views1 answer
Two selects in one query
SQL
0 vote250 views1 answer
MySql Modify Increment
SQL
0 vote257 views1 answer
Search starting with mysql
SQL
8 votes269 views1 answer
Oracle add datafile to tablespace
SQL
0 vote243 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote249 views1 answer
Mysql insert into select with recursive
SQL
0 vote250 views1 answer
How to check the port of mysql installation in mac
SQL