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

2 votes181 views1 answer
Oracle virtual column
SQL
0 vote186 views1 answer
Version and edition of SQL Server Database Engine
SQL
16 votes182 views4 answers
Sort by sql
SQL
0 vote139 views1 answer
How to set field to null in sql
SQL
0 vote217 views1 answer
Get only structure database mysql
SQL
1 vote170 views4 answers
Between vs in sql
SQL
0 vote195 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote211 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote194 views1 answer
Add a new column into table
SQL
0 vote180 views1 answer
Sql server 2012 create or alter procedure
SQL