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

11 votes269 views5 answers
How to install sqlite3 python
SQL
3 votes277 views2 answers
Sql not contains
SQL
0 vote288 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote292 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote286 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote294 views2 answers
Coursera spark sql max count
SQL
0 vote279 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
17 votes279 views4 answers
Sort by mysql
SQL
6 votes267 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
15 votes265 views2 answers
Select Options
SQL