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

0 vote176 views4 answers
Rownum in sql
SQL
1 vote99 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote135 views1 answer
Inner joint
SQL
0 vote156 views1 answer
Postgresql function ROUND
SQL
0 vote166 views3 answers
Constraint sql
SQL
0 vote143 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote142 views4 answers
Fatal database postgres does not exist
SQL
4 votes133 views1 answer
Check database name postgresql
SQL
0 vote152 views4 answers
What is unique key in sql
SQL
0 vote206 views1 answer
How to add auto increment primary key
SQL