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 vote188 views1 answer
Find wordpress version in database
SQL
0 vote155 views1 answer
Alter precision
SQL
3 votes165 views6 answers
DB::table('users')->get();
SQL
2 votes234 views1 answer
Db.relationship sqlalchemy flask
SQL
20 votes168 views4 answers
Reset auto increment in MySQL
SQL
0 vote146 views1 answer
Power query case when
SQL
3 votes153 views3 answers
C# sql select
SQL
-1 vote162 views2 answers
Postgresql get last 10 records
SQL
2 votes150 views1 answer
Import database in mysql command line xampp
SQL
0 vote170 views1 answer
Renommer schema sql
SQL