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 vote174 views2 answers
Mysql to python pandas
SQL
0 vote183 views1 answer
Postgres list all triggers
SQL
0 vote174 views2 answers
How covert into int in maria db
SQL
0 vote175 views1 answer
Python mysql show databases
SQL
0 vote189 views1 answer
How to map sql column to custom names
SQL
5 votes183 views3 answers
Day of week postgresql
SQL
0 vote175 views2 answers
Temp tables in sql server
SQL
2 votes187 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote189 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote173 views1 answer
Create database store
SQL