oracle - Where those sqlplus columns are used? -



oracle - Where those sqlplus columns are used? -

just type col in sqlplus returns list of columns, there columns ended _recyc, columns used ? googled not find documentation on them.

column droptime_plus_show_recyc on heading 'drop time' format a19 column objtype_plus_show_recyc on heading 'object type' format a12 column objectname_plus_show_recyc on heading 'recyclebin name' format a30 column origname_plus_show_recyc on heading 'original name' format a16

they're used show recyclebin command. if run headings like:

original name recyclebin name object type drop time ---------------- ------------------------------ ------------ ------------------- ...

if clear columns , run 1 time again get:

origname_plus_show_recyc objectname_plus_show_recyc objtype_plus_show_recyc droptime_plus_show_ -------------------------------- ------------------------------ ------------------------- ------------------- ...

whatever underlying query show recyclebin using (some variant of select .. user_recyclebin presumably) aliasing columns in resultset; sql*plus configured format aliased names.

the other pre-set column definitions similar; example, show edition gives column displayed heading edition, if clear columns reverts underlying name_col_plus_show_edition. _plus_show_ going output show command.

oracle sqlplus

Comments

Post a Comment

Popular posts from this blog

c# - ASP.NET MVC Sequence contains no matching element -

c# - ASP.NET MVC Sequence contains no matching element - i new asp.net mvc. have finished project unusual issue appeared in project. as seek run project error message. an exception of type 'system.invalidoperationexception' occurred in entityframework.dll not handled in user code additional information: sequence contains no matching element in 1 of controller using statement below groups display in dropdownlist. http://localhost....../clients (trying run page) , getting error on line containing code below. viewbag.groupdropdownvalues = new selectlist(db.groups.orderby(m => m.groupid), "groupid", "groupname"); or other controller: viewbag.categorydropdownvalues = new selectlist(db.category.orderby(m => m.categoryid), "categoryid", "categoryname"); this happening in controllers using syntax. i need display dropdownlists values database. working correctly till morning. don't have thought changed ,
Read more

java - Parsing XML, skip certain tags -

java - Parsing XML, skip certain tags - i next mkyong's great tutorial on how parse xml in java, have situation need read tags within area. e.g. <?xml version="1.0"?> <company> <staff id="1001"> <firstname>yong</firstname> <lastname>mook kim</lastname> <nickname>mkyong</nickname> <salary>100000</salary> </staff> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <salary>200000</salary> </staff> <changes> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <old_salary>175000</salary> <ne
Read more

rest - How to invalidate user session on inactivity in a stateless server? -

rest - How to invalidate user session on inactivity in a stateless server? - i'm building stateless restful server backend in java, used angularjs frontend. since should stateless, don't create sessions generate access tokens, more exactly json web tokens, client has nowadays on every request. the tokens contain "expires" field acts absolute expiration date. however, have additional expiration on user inactivity. define access token valid long 24 hours if user active 1 time every 30 minutes. i implement writing database on every request , verify time between requests, seems lot of work working out of box when using application server's session management. to 100% stateless on server side need force state logic client. solution is: issue jwt 2 expiry dates (one session - 30 minutes, sec refresh - 24h) implement getting new token same user previous token (new token has new expiry date session, same refresh) reject requests when whatever expir
Read more