41. How to give a list, column incorporation? SQL> Comment on Table Table IS 'Table Note'; comments have been created. SQL> Comment on column table. Column is 'column annotation'; comment has been created. SQL> SELECT * from user_tab_comments where comments is not null;
42. How do I check the condition of each table space? SQL> COL TABLESPACAT A20 SQL> SELECT B.FILE_ID File ID Number, B.Tablespace_name Table Space Name, B.bytes bytes (B.Bytes-Sum (NVL (A.Bytes, 0))) is used, SUM (NVL (A.bytes, 0)) Remaining Space, SUM (NVL (A.Bytes, 0)) / (B.bytes) * 100 Remaining Percentage from DBA_FREE_SPACE A, DBA_DATA_FILES B Where A.File_ID = B.File_ID Group By B.Tablespace_name, B.File_ID, B.BYTES ORDER BY B.FILE_ID 43. If the ORACLE is set to MTS or a dedicated mode? #Dispatches = "(Service = tcp)" Plus is MTS, the comment is a dedicated mode, and the SID refers to your instance name. 44. How can I know the current SCN number? Select Max (KTuxescnw * Power (2, 32) ktuxescnb) from x $ ktuxe; 45. How do I don't support it in Oracle? 9i does not support, 9i starts with TimeStamp 9i can use Select SystimeStamp from Dual; 46. How to get a return car in the string? SELECT 'WELCOME TO VIT' || CHR (10) || How does "in Chinese sorted? Before Oracle9i, Chinese is sorted according to binary coding. In Oracle9i, in accordance with Pinyin, Ministry, Sprinkler. Set NLS_SORT Value SCHINESE_RADICAL_M According to the first (first order), sort SCHINESE_STROKE_M Schinese_Stroke_m according to the stroke (first order), the first (second order) Sort Schinese_pinyin_m Follow the Pinyin 48. Oracle8i Object Name can be used in Chinese ? Can 49. How to change the SQL * PLUS boot option in WIN? SQL * Plus own option settings We can set in $ oracle_home / sqlplus / admin / glogin.sql.
50. How to modify the default date of the ORACEL database? ALTER session set nls_date_format = 'yyyyymmddhh24miss'; or may be plus a line of NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS' in INIT.ORA
