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 vote217 views1 answer
Select the date 30 days less that the todays date sql request
SQL
2 votes182 views1 answer
Postgresql update sequence next value
SQL
1 vote187 views2 answers
Postgresql remote connect
SQL
0 vote176 views1 answer
Mysql select statement after index
SQL
0 vote186 views1 answer
Database traccar
SQL
0 vote189 views1 answer
Order by in codeigniter query builder
SQL
1 vote170 views1 answer
Select dba users oracle
SQL
5 votes193 views4 answers
Select random rows sql
SQL
16 votes241 views3 answers
Order by sql query
SQL
1 vote191 views2 answers
How to drop a unique constraint in sql
SQL