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

7 votes341 views1 answer
Set sequence value oracle
SQL
1 vote354 views1 answer
Postgres start database on linux
SQL
1 vote351 views3 answers
Get all tables postgres
SQL
0 vote327 views1 answer
Select other columns with distinct
SQL
6 votes345 views1 answer
Wordpress change user password sql
SQL
0 vote337 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
13 votes341 views5 answers
Select last row mysql
SQL
0 vote376 views1 answer
Rename constraint postgresql
SQL
4 votes345 views1 answer
Mysql not equal
SQL
0 vote327 views1 answer
Create column that already exists mysql
SQL