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 vote195 views1 answer
Minus vs except in sql
SQL
1 vote192 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
-1 vote140 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote138 views1 answer
Opensuse status MySQL
SQL
12 votes154 views4 answers
How to check mysql version ubuntu
SQL
0 vote193 views1 answer
Fetching data from mysqldb
SQL
12 votes135 views2 answers
Delete all nodes neo4j
SQL
7 votes163 views2 answers
Sql remove duplicates based on column
SQL
0 vote140 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote132 views2 answers
Mysql set foreign_key_checks=0
SQL