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

3 votes341 views1 answer
RENAME table pl sql
SQL
2 votes317 views1 answer
Mysql auto increment jumping
SQL
9 votes376 views2 answers
SELECT User,Host FROM mysql.user;
SQL
17 votes345 views3 answers
Postgresql version command
SQL
0 vote339 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote350 views1 answer
Sql select where more than one record exists
SQL
11 votes380 views2 answers
Oracle saurce code
SQL
2 votes337 views2 answers
How to view created temporary tables in mysql
SQL
1 vote332 views3 answers
Mariadb add foreign key
SQL
3 votes350 views1 answer
Sql online test questions and answers
SQL