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

2 votes224 views2 answers
How to check data type in sql server
SQL
5 votes184 views1 answer
Oracle get nls settings
SQL
0 vote197 views1 answer
Mysql pv progres
SQL
0 vote187 views1 answer
Sql developer search all packages for text
SQL
0 vote209 views1 answer
Mysql join only one column
SQL
2 votes189 views2 answers
Set database timezone mysql
SQL
2 votes175 views1 answer
Oracle cpu per session
SQL
0 vote178 views1 answer
Oracle locked objects
SQL
0 vote195 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes175 views1 answer
Get first 2 letter in sql
SQL