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

-1 vote289 views10 answers
Delete Query in SQL Server
SQL
33 votes333 views2 answers
Postgres how to add field created at
SQL
0 vote311 views1 answer
Replace sqlalchemy
SQL
0 vote327 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote333 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote343 views1 answer
Dbms_output sql developer
SQL
0 vote334 views1 answer
Mysql not defined
SQL
0 vote558 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote347 views1 answer
Update having mysql
SQL
0 vote358 views1 answer
Mysql add to number
SQL