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

10 votes125 views1 answer
Create table oracle
SQL
0 vote129 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote132 views1 answer
Sql shell psql cannot enter password
SQL
0 vote142 views2 answers
Jsonb
SQL
1 vote124 views2 answers
Sql select only first occurrence
SQL
0 vote151 views1 answer
Sqlite trim
SQL
0 vote141 views1 answer
View to table sql
SQL
14 votes136 views2 answers
Oracle limit rows
SQL
1 vote144 views1 answer
Sql sort column by date
SQL
0 vote133 views1 answer
Create relationship with betwen two tables in postgersql
SQL