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

0 vote196 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote204 views1 answer
Write SQL in ruby on rails
SQL
37 votes247 views6 answers
Mysql update
SQL
0 vote174 views1 answer
QCompleter con sql
SQL
1 vote262 views1 answer
Continue in sql
SQL
0 vote192 views1 answer
Openquery insert into linked server
SQL
4 votes306 views6 answers
Laravel jwt
SQL
11 votes254 views3 answers
Pl sql example
SQL
2 votes199 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
9 votes230 views1 answer
Identity insert on sql server
SQL