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

5 votes320 views1 answer
AND OR NOT operators sql
SQL
0 vote301 views1 answer
Sqlite higher or equal
SQL
0 vote312 views4 answers
Rownum in sql
SQL
1 vote307 views1 answer
Moodle query first user access
SQL
1 vote292 views1 answer
Nested if in mysql
SQL
1 vote293 views1 answer
Stop mysql server mac
SQL
0 vote366 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote307 views1 answer
Mysql sql select one day before
SQL
0 vote313 views1 answer
With_for_update sqlalchemy
SQL
1 vote306 views1 answer
Sql eliminare un record
SQL