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 vote185 views1 answer
How to check database engine in mysql
SQL
0 vote159 views1 answer
Sql sort ages
SQL
0 vote153 views1 answer
Postgres in operator with comma separated values
SQL
16 votes190 views6 answers
Python sqlite
SQL
0 vote146 views1 answer
Sql server manager close connection
SQL
0 vote157 views1 answer
Sqlalchemy get ids
SQL
9 votes169 views2 answers
Convert data type in sql
SQL
25 votes172 views4 answers
Import mysql dump command line
SQL
0 vote143 views1 answer
Learn sqlite dart
SQL
0 vote161 views1 answer
Psql check if sql script is valid
SQL