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 vote62 views1 answer
Mysql sleep connections
SQL
0 vote101 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
6 votes100 views4 answers
Sqlite drop table
SQL
1 vote118 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote121 views2 answers
How to install psql in ubuntu
SQL
0 vote123 views1 answer
Mysql get only the field names in a table
SQL
-1 vote101 views3 answers
Check table exist postgresql
SQL
0 vote100 views1 answer
Mysql select all table that have field names
SQL
0 vote109 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote61 views1 answer
How to see the content of tables in pgadmin
SQL