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 vote270 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
1 vote267 views1 answer
Create new table from old table with data
SQL
0 vote276 views1 answer
Alter table change default
SQL
14 votes280 views2 answers
Install mysqldump
SQL
0 vote325 views1 answer
Reindexing all tables sql server
SQL
0 vote286 views1 answer
Space not removing from column in sql
SQL
0 vote318 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote226 views1 answer
How to set field to null in sql
SQL
0 vote271 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote276 views1 answer
How to see which columns are indexxed mysql
SQL