Select « Object Oriented Database « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Object Oriented Database
  3. Select
1.Display the New Table (SELECT * and SELECT by Column Name)
2.Query object table
3.Use type member function in select statement
4.SELECT Only One Column in the Composite
5.SELECT with a WHERE Clause
6.Query data from table based on object
7.SELECTing Individual Columns in TCROs
8.Use the function we created: use the table alias in our SELECT as well as the qualifier
9.Use * to reference column with user-defined type




10.demonstrates SQL operations on object types.
11.Select the object type from the table, rather than the columns.
12.Use %ROWTYPE to select from the relational table.