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 vote139 views1 answer
Partial search in sql
SQL
0 vote121 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote142 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
6 votes142 views2 answers
Postgresql restore from dump
SQL
0 vote129 views1 answer
Myswql show full processlist
SQL
5 votes131 views1 answer
Oracle ora-00054 causes
SQL
0 vote134 views1 answer
Mysql repair a table
SQL
0 vote131 views1 answer
Update top 100 sql
SQL
-1 vote138 views1 answer
Condition in orderby mysql
SQL
0 vote130 views2 answers
Update information in a mysql column
SQL