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 vote305 views1 answer
Mysql remove tabs from string
SQL
0 vote306 views1 answer
Sqlalchemy query return only n results
SQL
0 vote362 views1 answer
Sql query inline if
SQL
1 vote351 views2 answers
Full join
SQL
1 vote361 views2 answers
Install sql server management studio ubuntu
SQL
1 vote334 views1 answer
Avg mysql
SQL
0 vote332 views1 answer
Sql sum if
SQL
4 votes306 views1 answer
Oracle user tables
SQL
-1 vote361 views1 answer
Get month and year from date in mysql sequelize
SQL
3 votes301 views4 answers
Show columns from table
SQL