Oracle select

SELECT expressions
FROM tables
[WHERE conditions];

Source: techonthenet.com

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 vote255 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
3 votes165 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
1 vote159 views1 answer
Deleting database in sql
SQL
1 vote166 views1 answer
Select statement to print longest name
SQL
0 vote184 views1 answer
Postgresql using reserved word as column name
SQL
1 vote227 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
2 votes169 views1 answer
Mariadb JSON_EXTRACT
SQL
2 votes167 views1 answer
Sql find missing values between two tables
SQL
2 votes172 views1 answer
How to search table name in stored procedure in sql server
SQL
7 votes175 views2 answers
MySQL IF without else
SQL