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

1 vote225 views2 answers
Mysql remove first and last character from string
SQL
1 vote213 views1 answer
How to get mysql db size
SQL
1 vote234 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
4 votes180 views1 answer
And or sql order of operations
SQL
0 vote256 views1 answer
Stratified sampling sql
SQL
0 vote188 views0 answer
SQL
1 vote221 views2 answers
Select only columns that are not empty oracle sql
SQL
1 vote223 views1 answer
Oracle split string
SQL
0 vote251 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote231 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL