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 vote107 views1 answer
Insert or update cassandra
SQL
6 votes113 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote109 views1 answer
Renommer table sql
SQL
0 vote97 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote112 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote96 views1 answer
Minecraft duping allowed servers
SQL
16 votes110 views3 answers
Delete row psql
SQL
0 vote103 views1 answer
Check sql database table lock
SQL
6 votes121 views3 answers
What is where in sql
SQL
0 vote63 views0 answer
SQL