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 votes307 views3 answers
Mysql pass command from command line
SQL
14 votes289 views1 answer
Excel is not a database
SQL
1 vote334 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote297 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote289 views1 answer
Inner join distinct
SQL
0 vote296 views1 answer
SQL SELECT-Klausel
SQL
16 votes281 views1 answer
CTE statement sql server
SQL
14 votes343 views6 answers
Finding duplicate rows mysql
SQL
10 votes290 views2 answers
Forgot my mysql password mac
SQL
7 votes300 views3 answers
Add primary key to database sql
SQL