91. How to estimate the I / O number of SQL execution? SQL> set autotrace on; SQL> Select * from table; or sql> select * from v $ filestat; you can view the number of IO
92. How to change the field size under SQLPLUS? ALTER TABLE TABLE_NAME MODIFY (Field_name varcha2 (100)); changing the line, the change is not done (unless it is empty) 93. How to query a day of data? Select * from table_name where Where Trunc (Date Field) = To_date ('2003-05-02', 'YYYY-MM-DD'); 94. How does the SQL statement insert a full date? create table BSYEAR (d date); insert into BSYEAR select to_date ( '20030101', 'yyyymmdd') rownum-1 from all_objects where rownum <= to_char (to_date ( '20031231', 'yyyymmdd'), 'ddd'); 95. If you modify the table name? ALTER TABLE OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME; 96. How to get the return status value of the command? SQLCODE = 0 97. How do I know the permissions owned by the user? Select * from dba_sys_privs; 98. What is the difference between Oracle9i downloaded from the Internet? From the functional saying, Oracle has clearly defined; Oracle products downloaded from the website must not be used for commercial purposes, otherwise infringement.
99. How to determine that the database is running in archiving mode or running in non-invasive modes? Go to DBASTUDIO, History -> Database ---> Archive View. 100. SQL> Startup Pfile and IFILE, SPFILED What is the difference? Pfile is an Oracle traditional initialization parameter file, text format. Ifile is similar to include in C language, it is used to introduce another file into spfile. It is 9i new and is the default parameter file. After the binary format startup, only PFile should only be connected.
