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

3 votes234 views2 answers
Enter mysql command line
SQL
0 vote225 views1 answer
Trigger stock phpmyadmin
SQL
0 vote176 views1 answer
How to reset AI in sql
SQL
0 vote179 views1 answer
Get duplicate entry sql
SQL
1 vote134 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote189 views1 answer
Drop view in mysql
SQL
1 vote190 views2 answers
Insert sqlite
SQL
2 votes206 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote186 views1 answer
Restore backup mysql .gz
SQL
3 votes157 views1 answer
Oracle failed login attempts
SQL