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 vote248 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote162 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote177 views1 answer
Mariadb search columns
SQL
0 vote183 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote201 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote188 views1 answer
Postgresql create query
SQL
0 vote190 views1 answer
The fetch keyword oracle
SQL
11 votes181 views1 answer
Oracle insert into where
SQL
0 vote175 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote175 views1 answer
Oracle current timestamp
SQL