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 vote335 views1 answer
Postgresql copy backup table
SQL
0 vote368 views2 answers
Starting mysql service from mac
SQL
0 vote406 views1 answer
For row in sql database python loop
SQL
3 votes393 views1 answer
Sql set null
SQL
0 vote338 views1 answer
SQL get max per id
SQL
0 vote344 views1 answer
Get who is hired in january in sql
SQL
7 votes344 views1 answer
Query delete duplicates
SQL
0 vote395 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote382 views2 answers
Oracle create tablespace autoextend
SQL
8 votes377 views1 answer
Oracle add auto_increment column to existing table
SQL