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 vote207 views1 answer
How to update date add hours in postgresql
SQL
1 vote181 views1 answer
Postgresql update auto_increment value
SQL
0 vote228 views1 answer
Disable database droping sql
SQL
0 vote216 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote231 views1 answer
Sql sort ages
SQL
0 vote200 views4 answers
Sql year
SQL
0 vote206 views1 answer
Equi joins in oracle
SQL
0 vote191 views1 answer
Change default schema sql server
SQL
0 vote182 views2 answers
Change database postgres
SQL
50 votes226 views6 answers
Install mysql on ubuntu
SQL