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 vote223 views1 answer
Many rows to 1 string mysql
SQL
16 votes202 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote179 views1 answer
Postgres enumerated type
SQL
3 votes200 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote177 views1 answer
Primary key with prefix sql
SQL
1 vote250 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote172 views1 answer
Power query case when
SQL
14 votes208 views3 answers
SQL trim
SQL
1 vote193 views1 answer
Sql convert month name to number
SQL
25 votes174 views6 answers
Modify column name in mysql
SQL