Saturday, February 13, 2021

How to view sql*plus service status

SQL>> show all

  1. appinfo is OFF and set to "SQL*Plus"
  2. arraysize 15
  3. autocommit OFF
  4. autoprint OFF
  5. autorecovery OFF
  6. autotrace OFF
  7. blockterminator "." (hex 2e)
  8. btitle OFF and is the first few characters of the next SELECT statement
  9. cmdsep OFF
  10. colinvisible OFF
  11. colsep " "
  12. compatibility version NATIVE
  13. concat "." (hex 2e)
  14. copycommit 0
  15. COPYTYPECHECK is ON
  16. define "&" (hex 26)
  17. describe DEPTH 1 LINENUM OFF INDENT ON
  18. echo OFF
  19. editfile "afiedt.buf"
  20. embedded OFF
  21. errorlogging is OFF
  22. escape OFF
  23. escchar OFF
  24. exitcommit ON
  25. FEEDBACK ON for 6 or more rows
  26. flagger OFF
  27. flush ON
  28. fullcolname OFF
  29. heading ON
  30. headsep "|" (hex 7c)
  31. history is OFF
  32. instance "local"
  33. linesize 80
  34. lno 14
  35. loboffset 1
  36. lobprefetch 0
  37. logsource ""
  38. long 80
  39. longchunksize 80
  40. markup HTML OFF HEAD "SQL*Plus Report" BODY "" TABLE "border='1' width
  41. ='90%' align='center' summary='Script output'" SPOOL OFF ENTMAP ON PREFORMAT OFF
  42. markup CSV OFF DELIMITER , QUOTE ON
  43. newpage 1
  44. null ""
  45. numformat ""
  46. numwidth 10
  47. pagesize 14
  48. PAUSE is OFF
  49. pno 0
  50. recsep WRAP
  51. recsepchar " " (hex 20)
  52. release 1202000100
  53. repfooter OFF and is NULL
  54. repheader OFF and is NULL
  55. rowprefetch 1
  56. securedcol is OFF
  57. serveroutput OFF
  58. shiftinout INVISIBLE
  59. showmode OFF
  60. spool OFF
  61. sqlblanklines OFF
  62. sqlcase MIXED
  63. sqlcode 0
  64. sqlcontinue "> "
  65. sqlnumber ON
  66. sqlpluscompatibility 12.2.0
  67. sqlprefix "#" (hex 23)
  68. sqlprompt "SQL> "
  69. sqlterminator ";" (hex 3b)
  70. statementcache is 0
  71. suffix "sql"
  72. tab ON
  73. termout ON
  74. timing OFF
  75. trimout ON
  76. trimspool OFF
  77. ttitle OFF and is the first few characters of the next SELECT statement
  78. underline "-" (hex 2d)
  79. USER is "HRM"
  80. verify ON
  81. wrap : lines will be wrapped
  82. xmloptimizationcheck OFF


SQL>

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...