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

5 votes99 views5 answers
Find max number in sql
SQL
2 votes103 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
9 votes112 views2 answers
Convert data type in sql
SQL
6 votes98 views4 answers
Sqlite drop table
SQL
1 vote103 views1 answer
Postgres regex remove special characters
SQL
0 vote108 views1 answer
Time mysql w3
SQL
0 vote102 views1 answer
How to count with except in psql
SQL
0 vote112 views1 answer
Mysql delete from where like
SQL
5 votes93 views1 answer
Sql first day of current year
SQL
0 vote93 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL