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

4 votes259 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
9 votes523 views2 answers
Current date in postgresql minus 1 day
SQL
5 votes271 views1 answer
Sql use database
SQL
5 votes255 views2 answers
Update all rows mysql
SQL
13 votes282 views2 answers
Get date from now() mysql
SQL
0 vote291 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote283 views1 answer
Sort by
SQL
2 votes283 views1 answer
Mysql application.properties spring boot
SQL
1 vote283 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote301 views1 answer
Mysqldump: error:
SQL