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 vote338 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote335 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote318 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote321 views3 answers
How to truncate table with foreign key constraint
SQL
1 vote314 views1 answer
Convert varchar to int in sqlite
SQL
3 votes302 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote329 views1 answer
Postgres regex word boundary
SQL
5 votes316 views2 answers
Postgre insert select
SQL
0 vote306 views1 answer
Heidisql check how much space a row
SQL
0 vote312 views1 answer
Report in database
SQL