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

3 votes144 views2 answers
Brew restart mysql
SQL
0 vote101 views1 answer
How to stop all connections to a psql 12 database?
SQL
16 votes115 views6 answers
Python sqlite
SQL
0 vote74 views1 answer
Hangfire clean script
SQL
1 vote107 views2 answers
String to date postgres
SQL
1 vote138 views1 answer
Homebrew install mysql
SQL
0 vote129 views1 answer
Sql server create constraint
SQL
0 vote71 views1 answer
Count char in java
SQL
-1 vote103 views1 answer
Round up and down sql
SQL
3 votes110 views1 answer
Postgres count distinct
SQL