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 vote360 views1 answer
Mysql root localhost run
SQL
0 vote345 views2 answers
Mysql get routine parameter list
SQL
1 vote385 views1 answer
Oracle get current schema
SQL
5 votes366 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
19 votes337 views1 answer
Sqrt(-1)
SQL
0 vote366 views1 answer
Sql add calculated column
SQL
1 vote374 views1 answer
Postgresql create table with timestamp
SQL
1 vote365 views1 answer
Access the postgres psql
SQL
5 votes389 views1 answer
Sql add column after another
SQL
9 votes387 views3 answers
Postgres make sql dump
SQL