Login.sql

From Rohidekar

Revision as of 20:49, 2 November 2016 by Sarnobat (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Deprecated

set feedback 6
-- default is 6
set linesize 120
set long 55555
set numwidth 10
set pages 200
set serveroutput on
--set show on
-- Show column headings
set heading on
set sqlprompt "&_user@&_CONNECT_IDENTIFIER> "
set tab off
set wrap off
whenever sqlerror continue ;
whenever oserror continue ;

------------------------------------------------------------------------------
--                      Useful commands                                     -- 
------------------------------------------------------------------------------ 

-- Show your environment's current settings
-- show all


------------------------------------------------------------------------------
--                      Dictionary columns                                  --
------------------------------------------------------------------------------ 

column COLUMN_NAME                      format A30
column INDEX_NAME                       format A30

------------------------------------------------------------------------------
--                      Valid across all tests                              -- 
------------------------------------------------------------------------------


column COMPILED_ATTRIBUTE_COLUMN_NAME   format A20
column ENABLED_COLUMN_NAME              like COMPILED_ATTRIBUTE_COLUMN_NAME
column END_DATE_COLUMN_NAME             like COMPILED_ATTRIBUTE_COLUMN_NAME
column HIERARCHY_LEVEL_COLUMN_NAME      like COMPILED_ATTRIBUTE_COLUMN_NAME
column ID_COLUMN_NAME                   like COMPILED_ATTRIBUTE_COLUMN_NAME
column MEANING_COLUMN_NAME              like COMPILED_ATTRIBUTE_COLUMN_NAME
column START_DATE_COLUMN_NAME           like COMPILED_ATTRIBUTE_COLUMN_NAME
column SUMMARY_COLUMN_NAME              like COMPILED_ATTRIBUTE_COLUMN_NAME
column VALUE_COLUMN_NAME                like COMPILED_ATTRIBUTE_COLUMN_NAME

--column TEXT                             format A100000 wrapped

column ACTION_NAME                      format A30
column ADDITIONAL_QUICKPICK_COLUMNS     format A10
column ADDITIONAL_WHERE_CLAUSE          format A30                   word_wrapped
column APPLICATION_NAME                 format A30
column APPLICATION_SHORT_NAME           format A6
column APPLICATION_TABLE_NAME           format A30                   word_wrapped
column ASSOCIATION_CODE                 format A20
column ASSOCIATION_ID                   format 999999999999999
column ASSOCIATION_TYPE                 format A25
column ATTRIBUTE_GROUP_ID               format 9999999999
column ATTRIBUTE_ID                     format 999999999999999
column ATTRIBUTE_STRING_VALUE           format A20
column ATTR_DISPLAY_NAME                format A20
column ATTR_GROUP_DISP_NAME             format A30
column ATTR_GROUP_NAME                  format A30
column ATTR_GROUP_TYPE                  format A25
column CLASSIFICATION_CODE              format A20
column DATA_LEVEL_NAME                  format A20
column DEFAULTING                       format A1
column DESCRIPTION                      format A30
column DISPLAY_NAME                     format A20
column FLEX_VALUE                       format A25
column FLEX_VALUE_SET_NAME              format A30
column FORMAT_MEANING                   format A10
column FUNC_DISPLAY_NAME                format A30
column FUNC_TYPE_MEANING                format A8
column FUNCTION_INFO_1                  format A20
column FUNCTION_INFO_2                  format A20
column FUNCTION_NAME                    format A30
column INTERNAL_NAME                    format a20
column INVENTORY_ITEM_ID                format 999999999999999
column ITEM_CATALOG_GROUP_ID            format 999999999999999
column LANGUAGE                         format A10
column LONGLIST_FLAG_MEANING            format A10
column LOOKUP_CODE                      format A11
column MAXIMUM_SIZE                     format 999
column MAXIMUM_VALUE                    format A9
column MEANING                          format A40
column MINIMUM_VALUE                    format A9
column NAME                             format A20
column OBJECT_LOCATION                  format A30
column OBJECT_NAME                      format A40
column bugfix_name                      format A10
--column OBJECT_NAME                      format A20
column OBJ_NAME                         format A30
column ORGANIZATION_NAME                format A30
column PK1_COLUMN_NAME                  format A15
column PK2_COLUMN_NAME                  like PK1_COLUMN_NAME
column PK3_COLUMN_NAME                  like PK1_COLUMN_NAME
column PK4_COLUMN_NAME                  like PK1_COLUMN_NAME
column PK5_COLUMN_NAME                  like PK1_COLUMN_NAME
column REVISION_ID                      format 9999999999
column SEGMENT1                         format A20
column TABLE_ID                         format 999999
column TEXT                             format A55555                word_wrapped
column USER_DATA_LEVEL_NAME             format A30
column VALIDATION_CODE                  format A7
column VALIDATION_MEANING               format A20
column VALUE_SET_NAME                   format A30
column VENDOR_NAME                      format A30
column WEB_HTML_CALL                    format A60 word_wrapped
--column NAME                             format A20 -- DOESN't WORK for Desc

------------------------------------------------------------------------------
--              Valid only for specific tests (i.e. aliases)                -- 
------------------------------------------------------------------------------

column CHILD_VALUE_SET_ID               format 9999999999
column CHILD_VALUE_SET_NAME             format A30
column CREATE_CHILD_VS_SWITCHER         format A2
column C_EXT_ATTR1                      format A10 word_wrapped
column C_EXT_ATTR2                      like C_EXT_ATTR1
column C_EXT_ATTR3                      like C_EXT_ATTR1
column C_EXT_ATTR4                      like C_EXT_ATTR1
column C_EXT_ATTR5                      like C_EXT_ATTR1
column C_EXT_ATTR6                      like C_EXT_ATTR1
column C_EXT_ATTR7                      like C_EXT_ATTR1
column C_EXT_ATTR8                      like C_EXT_ATTR1
column C_EXT_ATTR9                      like C_EXT_ATTR1
column C_EXT_ATTR10                     like C_EXT_ATTR1
column DISPLAYED_VALIDATION_MEANING     format A20
column ITEM_ID                          format 999999
column ORG_ID                           format 999999
column PARENT_VALUE_SET_ID              format 9999999999
column PARENT_VALUE_SET_NAME            format A20
column TRUE_VALIDATION_MEANING          format A20
column VALUE                            format a20
column VALUE_DESCRIPTION                format a20
column VALUE_ENABLED_MEANING            format a3
column VALUE_INTERNAL_NAME              format a20
column VALUE_SET_ID                     format 9999999999
column VALUE_SET_VALUE_ID               format 9999999999
column VALUE_SET_VALUE_NAME             format A30
column V_CHILD_VALUE_SET_ID_1           format 999999999
column V_CHILD_VALUE_SET_ID_2           format 999999999
column USER_ATTR_DISPLAY_NAME           format A40
column ITEM1_USERATTRVAL                format A20
column ITEM2_USERATTRVAL                like ITEM1_USERATTRVAL
column FILENAME                         format A35

-- Prevent ORU-10027 errors
exec dbms_output.enable('10000000000');
Personal tools