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 vote204 views2 answers
Functions with parameters SQL
SQL
0 vote197 views1 answer
How to login to mysql in homestead
SQL
2 votes200 views1 answer
Sql server current date minus 5 years
SQL
6 votes245 views3 answers
What is where in sql
SQL
-1 vote210 views1 answer
Auto increment psql not primary key
SQL
0 vote191 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote200 views1 answer
Get schema of table sql
SQL
0 vote187 views1 answer
Show all mongodb
SQL
16 votes230 views1 answer
Sqlserver add column to table
SQL
4 votes157 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL