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

1 vote210 views1 answer
Sql first
SQL
0 vote152 views1 answer
Mysql select top 2
SQL
0 vote183 views1 answer
Grant privileges of databse to user
SQL
5 votes223 views2 answers
Postgresql insert select
SQL
3 votes208 views5 answers
Foreign keys
SQL
11 votes242 views2 answers
Docker create postgres db
SQL
0 vote179 views1 answer
Mysql convert charset
SQL
0 vote294 views1 answer
Placements hackerrank solution
SQL
2 votes250 views1 answer
Merge two columns in sql oracle
SQL
0 vote188 views1 answer
On update current_timestamp jpa
SQL