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

1 vote244 views1 answer
Check current sequence value postgres
SQL
0 vote221 views1 answer
Primary key start from number
SQL
0 vote207 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
8 votes235 views1 answer
Ltrim sql
SQL
2 votes210 views1 answer
Oracle convert run_duration to number
SQL
14 votes204 views2 answers
Oracle add column with default value
SQL
0 vote201 views1 answer
Exclude last comma separated string mysql
SQL
0 vote218 views1 answer
How to move a column to different spot mysql
SQL
0 vote201 views1 answer
Sql case when exists in another table
SQL
0 vote211 views1 answer
Write SQL in ruby on rails
SQL