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 vote131 views1 answer
Postgresql isnull with max
SQL
5 votes149 views3 answers
Sql server utc to local
SQL
0 vote139 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
3 votes161 views1 answer
Force using index oracle
SQL
0 vote150 views2 answers
Advantages of stored procedures sql
SQL
1 vote143 views2 answers
How to drop a unique constraint in sql
SQL
0 vote171 views1 answer
Suhaib
SQL
1 vote155 views1 answer
Mysql select for update ejemplo
SQL
0 vote127 views1 answer
Mysql sql select one day before
SQL
0 vote134 views2 answers
Sql drop view if exists
SQL