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 vote116 views1 answer
Mysql return column names when table is empty
SQL
0 vote115 views1 answer
Mysql create table like
SQL
0 vote116 views1 answer
Sql query for select from specific columns in a table
SQL
8 votes120 views2 answers
Alert table name mysql
SQL
1 vote119 views2 answers
Mysql order by date asc null last
SQL
0 vote122 views1 answer
Oracle table privileges
SQL
7 votes137 views2 answers
How to create index mysql
SQL
0 vote139 views1 answer
Sqlite woth cmake
SQL
0 vote117 views1 answer
Postgres create extension if not exists
SQL
0 vote127 views1 answer
Yesql
SQL