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 ofshow
options, excepterrors
,sga
, in alphabetical order.show parameters
orshow parameters parameter_name
- displays current values 1 or more initialization parameters; without string following command displays initialization parameters. needselect on v_$parameter
object privileges useparameters
clause.show spparameters
orshow 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
orshow 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 specifyshow 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. needselect on v_$sga
object privileges.show recyclebin
- shows objects in recycle bin can revertedflashback before drop
command.
Comments
Post a Comment