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 votes200 views1 answer
Capitalize 1st letter in sql server
SQL
3 votes163 views1 answer
Index using in query plsql
SQL
0 vote185 views1 answer
Check constraint is violated
SQL
0 vote169 views1 answer
Drop all tables in azure sql database
SQL
23 votes164 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote180 views1 answer
Get last date join sql
SQL
0 vote193 views1 answer
How to select only a certain date sql
SQL
0 vote194 views1 answer
Example database query
SQL
3 votes157 views1 answer
Oracle get trigger ddl
SQL
1 vote181 views1 answer
Sql select all from one table and one column from another
SQL