Oracle function select into

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 votes151 views3 answers
Update con select postgresql
SQL
0 vote126 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote153 views2 answers
Impala rename column name
SQL
0 vote136 views1 answer
Restore backup mysql .gz
SQL
0 vote128 views1 answer
Create a table from one field of another table
SQL
1 vote125 views1 answer
Postgres grant read only access to database
SQL
1 vote129 views1 answer
Mysql server does not start mac
SQL
6 votes141 views2 answers
Oracle trigger
SQL
44 votes208 views6 answers
Rename command in sql
SQL
12 votes144 views10 answers
Google
SQL