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 vote224 views1 answer
Mysql connect bash
SQL
0 vote211 views1 answer
Character count sql
SQL
0 vote193 views3 answers
Postgres trim string
SQL
6 votes210 views2 answers
Mysql timestamp to date
SQL
0 vote182 views1 answer
Oracle synonym procedure
SQL
0 vote231 views10 answers
Sql statement checker corrector
SQL
-1 vote193 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote223 views1 answer
Mysql changer nom table
SQL
0 vote196 views1 answer
Sqlite3 get data from table c
SQL
0 vote183 views1 answer
Oracle locked objects
SQL