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 vote251 views1 answer
Round one decimal place mysql
SQL
0 vote155 views1 answer
FindAllBy
SQL
0 vote243 views1 answer
Select top 3 sql
SQL
28 votes163 views6 answers
Distinct sql
SQL
0 vote237 views1 answer
Error code 1451 sql
SQL
0 vote264 views1 answer
Pl sql round
SQL
0 vote167 views1 answer
Copy table dbeaver
SQL
2 votes309 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote203 views1 answer
Postgresql stored procedure update table values
SQL
0 vote211 views1 answer
Mysqli_connect using prepare statement
SQL