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 vote149 views1 answer
Systems sql
SQL
7 votes144 views1 answer
Oracle pagination query offset
SQL
0 vote147 views1 answer
Check if has alpha characters sql
SQL
5 votes132 views1 answer
Mysql change primary key
SQL
12 votes131 views4 answers
Mysql get date difference in hours
SQL
0 vote144 views1 answer
Datatables server side filter where clause
SQL
0 vote131 views3 answers
Average salary in sql
SQL
0 vote136 views1 answer
Postgres read table structure
SQL
5 votes150 views1 answer
Mysql count newlines in field
SQL
2 votes133 views1 answer
Mysql how to store lat,lng
SQL