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 vote118 views1 answer
How to install sql in anaconda
SQL
-1 vote145 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote68 views1 answer
Psql not found windows
SQL
0 vote115 views2 answers
Add colum in sql
SQL
4 votes113 views6 answers
Sql select statement
SQL
0 vote121 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote136 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote120 views1 answer
Display first three characters sql
SQL
4 votes151 views1 answer
Mysql query first character
SQL
0 vote127 views1 answer
Automated psql csv export script on windows
SQL