SQL> create table myTable 2 (c1 varchar2(80) ) 3 organization external 4 ( 5 type oracle_loader 6 default directory infile 7 access parameters 8 ( 9 records delimited by newline 10 fields 11 (c1 char(80) ) 12 ) 13 location ('xml.lst') 14 ) 15 / SQL> SQL> SQL> select * from myTable 2 where rownum <= 5; SQL> drop table myTable;
6.1.Create Table | ||||
6.1.1. | Creating a Table | |||
6.1.2. | Create table with storage setting | |||
6.1.3. | Create table with storage setting 2 | |||
6.1.4. | Create an external table | |||
6.1.5. | Create copy table | |||
6.1.6. | Create a table from one or more other tables | |||
6.1.7. | Rename a table | |||
6.1.8. | One column with three constraints | |||
6.1.9. | Use referencing columns | |||
6.1.10. | Create a table based on a hash cluster | |||
6.1.11. | Create table with 'organization index OVERFLOW' | |||
6.1.12. | Create table with 'organization index' | |||
6.1.13. | Cascade delete setting | |||
6.1.14. | Demonstrate a simple External table | |||
6.1.15. | Create intermediate table for calculation | |||
6.1.16. | Make myCode a CACHE table. |