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

8 votes286 views3 answers
Oracle auto_increment
SQL
1 vote306 views1 answer
How to put value in variable mysql
SQL
0 vote265 views1 answer
Add column to table with default value plsql
SQL
0 vote291 views1 answer
How to query without duplicate rows in sql
SQL
2 votes296 views2 answers
How to run postgresql in linux
SQL
0 vote276 views1 answer
Windows services sql
SQL
0 vote288 views1 answer
Mysql root permission denied lost
SQL
1 vote319 views1 answer
Oracle select first row order by
SQL
0 vote260 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote300 views2 answers
Sql day from datetime
SQL