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 vote231 views1 answer
Sql multiple into
SQL
0 vote195 views1 answer
How should I pass a table name into a stored proc?
SQL
1 vote262 views1 answer
Continue in sql
SQL
2 votes236 views2 answers
How to add not null constraint in sql
SQL
0 vote195 views1 answer
Mysql search like but first exact match
SQL
0 vote225 views1 answer
Oracle enable chain
SQL
6 votes229 views5 answers
Oracle list tablespaces
SQL
1 vote203 views1 answer
Clear screen command in psql
SQL
0 vote212 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote208 views1 answer
Full sql mode
SQL