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 vote236 views1 answer
How to get the date diff on once field in sql server
SQL
3 votes242 views1 answer
How to add unique constraint in mysql table
SQL
3 votes220 views1 answer
Créer une table sql
SQL
18 votes220 views3 answers
Find column name in database
SQL
0 vote240 views1 answer
Remove mysql from centos 7
SQL
5 votes214 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote218 views1 answer
Oracle sql drop table
SQL
0 vote211 views1 answer
Excute raw query
SQL
0 vote231 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote201 views1 answer
How to print longest name in sql
SQL