oracle - How to know what SETS are ON in SQL PLUS? -


is there way in sql plus know state of set commands?

for example whether or not wrap set off or on, etc..

i've searched online , couldn't find anything. thought might similar set cmd, if try this:

set 

you get:

sp2-0545: set command requires argument.

how can value of current sets?

in case not being clear, want know if there command similar this:

show sets 

that return like

wrap on  long 3000 linesize 344 verify off etc.. 

you can use show command:

  • show all - lists settings of show options, except errors , sga, in alphabetical order.
  • show parameters or show parameters parameter_name - displays current values 1 or more initialization parameters; without string following command displays initialization parameters. need select on v_$parameter object privileges use parameters clause.
  • show spparameters or show spparameters parameter_name - show parameters except displays current values initialization parameters instances.

there other options associated show including (see link above further options):

  • show errors or show errors {function | procedure | package | package body | trigger | view | type | type body | dimension | java class} schema.name - shows compilation errors of stored procedure (includes stored functions, procedures, , packages). when specify show errors no arguments, sql*plus shows compilation errors created or altered stored procedure. when specify type , name of pl/sql stored procedure, sql*plus shows errors stored procedure.
  • show sga - displays information current instance's system global area. need select on v_$sga object privileges.
  • show recyclebin - shows objects in recycle bin can reverted flashback before drop command.

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -