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 vote341 views1 answer
Mysql drop trigger
SQL
0 vote322 views1 answer
Mysql conf.d exampel
SQL
13 votes329 views4 answers
Command line mysql import
SQL
0 vote323 views1 answer
Zerar auto increment mysql
SQL
1 vote321 views2 answers
T sql get foreign key
SQL
6 votes326 views1 answer
Oracle trigger after logon on schema
SQL
11 votes765 views4 answers
Reset identity column values in sql server
SQL
4 votes314 views1 answer
Oracle user tables
SQL
22 votes324 views4 answers
Mysql reset auto increment id
SQL
2 votes342 views2 answers
Postgres trigger insert into another table
SQL