-
编辑 删除
Oracle Views
Version 11.1 GeneralNOTE: A view is a logical entity. It is a SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the databa...
-
编辑 删除
Oracle Select Statements
Version 11.1 Basic Select Statements Select All Columns and All Records in a Single Table or View SELECT *FROM <table_name>; SELECT *FROM all_tables; Select Named Columns SELEC...
-
编辑 删除
Oracle Insert Statements
Version 11.1 Basic InsertsSingle Column Table Or ViewINSERT INTO <table_name>(<column_name>)VALUES(<value>);CREATE TABLE state (state_abbrev VARCHAR2(2));INSERT INTO state(state_...
-
编辑 删除
Oracle Update Statements
Basic Update StatementsUpdate all recordsUPDATE <table_name>SET <column_name> = <value>CREATE TABLE test ASSELECT object_name, object_typeFROM all_objs;SELECT DISTINCT object_nameFROM test;UPD...
