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 vote157 views1 answer
Sql server information_schema temp tables
SQL
0 vote128 views1 answer
Backup a table in sql
SQL
0 vote140 views2 answers
Sql query for getting details by id
SQL
2 votes142 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote124 views1 answer
Select all tables linked server sql
SQL
0 vote165 views1 answer
Get first monday of month sql
SQL
1 vote175 views1 answer
Connect to mysql database ubuntu
SQL
0 vote126 views1 answer
Check sql database table lock
SQL
0 vote136 views1 answer
Mysql grant grant option
SQL
0 vote130 views1 answer
Sql with example
SQL