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

1 vote353 views1 answer
Delete specific row in sql
SQL
1 vote328 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
7 votes364 views1 answer
Return insert results in POSTGRESQL
SQL
12 votes378 views10 answers
Google
SQL
12 votes353 views4 answers
Mysql get date difference in hours
SQL
1 vote391 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote352 views1 answer
Db format in quotation
SQL
25 votes434 views4 answers
Import mysql dump command line
SQL
0 vote341 views2 answers
Insert into
SQL
0 vote362 views1 answer
Alter rename command in mysql
SQL