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 vote299 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote311 views1 answer
Oracle sql number to varchar2
SQL
1 vote317 views1 answer
Round function in sql oracle
SQL
4 votes347 views3 answers
Postgres drop all tables
SQL
9 votes316 views3 answers
Mysql show table column full description
SQL
2 votes318 views1 answer
Oracle sql merge
SQL
0 vote301 views1 answer
Sql clear table
SQL
4 votes332 views1 answer
Sql select limit range
SQL
0 vote308 views1 answer
Mysql loop through databases and execute query
SQL
13 votes351 views3 answers
Mysqldump structure only
SQL