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 vote291 views1 answer
Sqlite display data in separated columns
SQL
9 votes210 views3 answers
Where in sql
SQL
0 vote227 views1 answer
Code to move ietms from one table to another myswl
SQL
1 vote213 views1 answer
Postgres check blocking
SQL
0 vote243 views3 answers
Characters found after end of sql statement
SQL
0 vote222 views2 answers
Identity column in sql server
SQL
0 vote218 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote236 views1 answer
How to generate ids in sql
SQL
0 vote209 views1 answer
Sqlserver now
SQL
3 votes196 views1 answer
Sql replace character in string in all records
SQL