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 vote264 views1 answer
How to connect postgresql database with java
SQL
1 vote319 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote270 views1 answer
Python mysql query to dataframe
SQL
1 vote285 views2 answers
Grab part of a string sql
SQL
0 vote266 views1 answer
How to find username and password in oracle 18c
SQL
1 vote270 views1 answer
Query for all indexes in table postgres
SQL
3 votes291 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
3 votes287 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote276 views1 answer
Postgres set default schema
SQL
1 vote272 views1 answer
Postgresql blocked on mac
SQL