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 vote83 views1 answer
Sql count how many times a value appears
SQL
0 vote120 views1 answer
Sql server select furst day of current year
SQL
1 vote145 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote117 views1 answer
Composit key in sql
SQL
0 vote144 views1 answer
Mysql into outfile with headers
SQL
0 vote125 views1 answer
Mysql_error replacement
SQL
0 vote122 views1 answer
Sql server udf performance
SQL
1 vote174 views1 answer
Sqlite show columns in table
SQL
0 vote125 views1 answer
Plpgsql raise notice
SQL
5 votes124 views1 answer
Ignore duplicate rows in sqlite
SQL