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 vote292 views1 answer
Ms Sql set us timezone
SQL
0 vote304 views1 answer
Sqlite update where exists
SQL
1 vote327 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote316 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote316 views1 answer
Convert rows to columns in sql server
SQL
2 votes339 views1 answer
Mysql create user with remote access
SQL
0 vote301 views3 answers
Drop multiple columns in sql
SQL
0 vote304 views1 answer
Sql delete dastabase
SQL
0 vote318 views1 answer
Mysql loop through databases and execute query
SQL
11 votes332 views5 answers
Update table from another table mysql
SQL