Oracle points 2 (SQLPLUS)

xiaoxiao2021-03-06  39

1. Change the current login user password Password2. Default SQLPLUS editor (including UNIX) Windows (add the following): Define_Editor = '' C: / Program Files / Ultraedit / Uedit32.exe 'UNIX (SOLAIRS): Define_Editor = VI3. Continuous Rat 4.spool command Use 5. Note Remarks6.show all7.help set8. Runtime Accept value, use accept command 9. How to see the port single line function for isqlplus: Concat (A, NULL) and A || NULL distinguishes Length, Lengthb, VSIZE (X) Different meaning sys_context why Sys_Context does not use table (4 chapter) Distinct NULL how to calculate the size, Substr (RowID, 1, 15) uses a form name, The associated columns must use alias a single quote from NULL, and multiple single quotes are not.

转载请注明原文地址:https://www.9cbs.com/read-75873.html

New Post(0)