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 vote173 views3 answers
Sql union
SQL
7 votes167 views2 answers
Html to react converter
SQL
1 vote211 views1 answer
How to get alternate records from a table in sql
SQL
4 votes179 views2 answers
Bulk kill mysql processlist
SQL
0 vote171 views1 answer
Postgresql create table with boolean column
SQL
2 votes156 views1 answer
Mysql auto increment jumping
SQL
28 votes165 views4 answers
Show tables mysql
SQL
0 vote172 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote177 views1 answer
Oracle cpu metric
SQL
0 vote172 views1 answer
Mysql coonect sample code
SQL