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 vote195 views1 answer
Sql quary intervewi question
SQL
10 votes159 views2 answers
Mysql select timestamp group by day
SQL
0 vote189 views2 answers
Sqlalchemy core in clause
SQL
11 votes199 views3 answers
How to get last row of table in sql
SQL
0 vote185 views1 answer
My sql data file extention
SQL
0 vote205 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote179 views1 answer
Change table to innodb mysql
SQL
-2 votes199 views2 answers
Union vs union all in sql
SQL
0 vote181 views1 answer
Mysql grant access to one database
SQL
0 vote182 views1 answer
Power bi find all ids not in other tables
SQL