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 vote77 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote76 views1 answer
Acutal month year
SQL
1 vote77 views1 answer
Sql server update column based on another table
SQL
1 vote81 views1 answer
Base64 encode sql server
SQL
0 vote74 views1 answer
Postgresql comandos basicos
SQL
1 vote85 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote75 views1 answer
Get first monday of month sql
SQL
51 votes126 views6 answers
Change column name sql
SQL
0 vote74 views1 answer
Sql server list user permissions
SQL
0 vote84 views1 answer
Min varias colunas spark sql
SQL