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 vote124 views1 answer
Drop constraint in ms sql
SQL
35 votes137 views5 answers
Sql alter column
SQL
0 vote82 views1 answer
Mssql view column data type
SQL
0 vote192 views2 answers
Fanyi
SQL
18 votes131 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote125 views1 answer
Number(10 2) in sql means
SQL
0 vote118 views1 answer
Create table employees oracle
SQL
1 vote121 views1 answer
Update from select join
SQL
0 vote127 views1 answer
Sql tabelle erstellen
SQL
0 vote126 views1 answer
Sql get number of days between two dates
SQL