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

4 votes229 views1 answer
Adding data to table in sql python
SQL
0 vote232 views1 answer
Sql cheetsheet
SQL
10 votes260 views2 answers
Doublon sql
SQL
0 vote245 views1 answer
Set Mamp mysql globally
SQL
0 vote248 views1 answer
Sql check for null and empty string
SQL
1 vote240 views1 answer
Mysql f# examples
SQL
0 vote241 views1 answer
Sql sum show 0 result
SQL
6 votes228 views1 answer
How to count number of rows in sql
SQL
0 vote183 views1 answer
Ms sql print more than 1 variable
SQL
-1 vote234 views1 answer
Condition in orderby mysql
SQL