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 vote186 views1 answer
Longtext sql
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
1 vote200 views3 answers
Union in sql
SQL
5 votes182 views1 answer
Sql first day of current year
SQL
0 vote192 views1 answer
Mysql join same table multiple times group by
SQL
0 vote200 views1 answer
How many rows affected in sqllite
SQL
0 vote183 views1 answer
Sql row number in result set
SQL
4 votes183 views1 answer
Sql quote in string
SQL
1 vote238 views1 answer
Drop colum oracle 18c
SQL
0 vote192 views1 answer
MySQL FIND_IN_SET()
SQL