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 vote275 views2 answers
Mysql multiply
SQL
0 vote505 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
4 votes266 views1 answer
Oracle show error line number
SQL
0 vote294 views1 answer
Sql comand for removing data from table
SQL
0 vote295 views1 answer
Oracle query archive mode
SQL
10 votes297 views2 answers
Sql pagination offset
SQL
0 vote303 views1 answer
Mysql disable triggers
SQL
-1 vote297 views1 answer
Window functions in sql
SQL
0 vote318 views1 answer
Mysqldump: error:
SQL
1 vote300 views2 answers
Get table column names sql laravel
SQL