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 vote196 views4 answers
Get week day from date in sql
SQL
0 vote185 views1 answer
Mysql docker image for macbook m1
SQL
0 vote183 views1 answer
Mysql workbench indent formatting
SQL
3 votes199 views2 answers
See mysql users ubuntu
SQL
2 votes199 views3 answers
Sql interview query questions
SQL
1 vote182 views1 answer
Mariadb alter user host
SQL
2 votes244 views2 answers
Postgres set user as superuser
SQL
0 vote182 views1 answer
Drop all tables db2
SQL
0 vote186 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote255 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL