Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Permanently define options such as "set pagesize..set linesize..."

Murray SobolMar 26 2015 — edited Mar 30 2015

Is it possible to define options such as "set pagesize..set linesize..." permanently??

Currently 4.1 EA2 (possibly prior versions) when I issue a select statement such as" select * from a1_user", I get this result:

USER_ID                                  FULL_NAME                                          PASSWORD                                                                                   HIDE_PRICE_FLAG SIGNATURE                                                                                                                        PASSWORD_DATE           INACTIVE_FLAG WEB_FLAG ADD_DATE                SOP_COST_PRICE_FLAG LANGUAGE_CODE E_MAIL                                                                                                                           OVERRIDE_IV_COST_FLAG ABC_FLAG   SCALE_OPERATOR_FLAG WORKSTATION_SERIAL_NBR PO_RECEIVING_COST_FLAG ACCESS_TO_CO_BU_FLAG PROPHETX_USER_ID                                                                                                                                                                                                                                         
---------------------------------------- -------------------------------------------------- ------------------------------------------------------------------------------------------ --------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------- ------------- -------- ----------------------- ------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- ---------- ------------------- ---------------------- ---------------------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MARKET_INTERFACE_URL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ALLOW_OVERRIDE_OT_PRICE_FLAG LAST_LOGIN_DATE         DOLLAR_LIMIT_SERIAL_NBR USER_DOLLAR_LIMIT_SERIAL_NBR CREDIT_ADMIN_FULL_NAME                             CREDIT_ADMIN_FLAG CREDIT_ADMIN_INACTIVE_FLAG DUPLICATE_NA_FLAG ALLOW_CONSOLID_CUSTOMER_FLAG ACCESS_TO_REL_IN_TE_FLAG VIEW_NA_PIN_NUMBER_FLAG VIEW_ONLY_NA_PROFILE_FLAG ALLOW_CONTACT_INACTIVATE_FLAG
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- ----------------------- ----------------------- ---------------------------- -------------------------------------------------- ----------------- -------------------------- ----------------- ---------------------------- ------------------------ ----------------------- ------------------------- -----------------------------
PROPHETX_INTERFACE_PASSWORD                                                                                                                                                                                                                                RELEASE_BUILD_INFO   PRODUCTION_PLANNER_FLAG ACCESS_TO_BLANK_ACCR_VEN_FLAG STDIO_WINDOWS_SERVICE_FLAG STDIO_WS_SERVER_NAME                                                                                                                                                                                                                                             STDIO_LAST_RUN       
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- ----------------------- ----------------------------- -------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------
GSBAT420SACBH001                         SMART BHC Purchase, Sale, Transfer                 225210249249253245232218                                                                   N                                                                                                                                                27-AUG-2002 09.47.36 AM N             Y        13-JAN-2005 11.18.40 AM N                   EN                                                                                                                                             Y                                N                                          N                      N                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 N                                                                          1                            1                                                    N                 N                          N                 N                            Y                        N                       N                         Y                            
                                                                                                                                                                                                                                                                                N                       Y                             N                                                                                                                                                                                                                                                                                                                 

FRED                                     Fred Cornish                                       225210249249253245232218                                                                   N                                                                                                                                                27-AUG-2002 09.47.36 AM N             N        13-JAN-2005 11.18.40 AM N                   EN                                                                                                                                             Y                                N                                          N                      N                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 N                                                                          1                            1 Fred Cornish                                       Y                 N                          N                 N                            Y                        N                       N                         Y                            
                                                                                                                                                                                                                                                                                N                       Y                             N                                                                                                                                                                                                                                                                                                                 

However, if add these 2 commands:

set linesize 10000

set pagesize 1000 and then reissue the same SQL statement "select * from a1_user" I get this result:

USER_ID                              FULL_NAME                                      PASSWORD                                                                               HIDE_PRICE_FLAG SIGNATURE                                                                                                                    PASSWORD_DATE       INACTIVE_FLAG WEB_FLAG ADD_DATE            SOP_COST_PRICE_FLAG LANGUAGE_CODE E_MAIL                                                                                                                       OVERRIDE_IV_COST_FLAG ABC_FLAG   SCALE_OPERATOR_FLAG WORKSTATION_SERIAL_NBR PO_RECEIVING_COST_FLAG ACCESS_TO_CO_BU_FLAG PROPHETX_USER_ID                                                                                                                                                                                                                                       MARKET_INTERFACE_URL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         ALLOW_OVERRIDE_OT_PRICE_FLAG LAST_LOGIN_DATE     DOLLAR_LIMIT_SERIAL_NBR USER_DOLLAR_LIMIT_SERIAL_NBR CREDIT_ADMIN_FULL_NAME                         CREDIT_ADMIN_FLAG CREDIT_ADMIN_INACTIVE_FLAG DUPLICATE_NA_FLAG ALLOW_CONSOLID_CUSTOMER_FLAG ACCESS_TO_REL_IN_TE_FLAG VIEW_NA_PIN_NUMBER_FLAG VIEW_ONLY_NA_PROFILE_FLAG ALLOW_CONTACT_INACTIVATE_FLAG PROPHETX_INTERFACE_PASSWORD                                                                                                                                                                                                                            RELEASE_BUILD_INFO   PRODUCTION_PLANNER_FLAG ACCESS_TO_BLANK_ACCR_VEN_FLAG STDIO_WINDOWS_SERVICE_FLAG STDIO_WS_SERVER_NAME                                                                                                                                                                                                                                         STDIO_LAST_RUN   

---------------------------------------- -------------------------------------------------- ------------------------------------------------------------------------------------------ --------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------- ------------- -------- ----------------------- ------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- ---------- ------------------- ---------------------- ---------------------- -------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- ----------------------- ----------------------- ---------------------------- -------------------------------------------------- ----------------- -------------------------- ----------------- ---------------------------- ------------------------ ----------------------- ------------------------- ----------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- ----------------------- ----------------------------- -------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------

GSBAT420SACBH001                     SMART BHC Purchase, Sale, Transfer             225210249249253245232218                                                               N                                                                                                                                            27-AUG-2002 09.47.36 AM N         Y    13-JAN-2005 11.18.40 AM N               EN                                                                                                                                         Y                            N                                      N                  N                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            N                                                                      1                        1                                                N             N                      N             N                        Y                    N                   N                     Y                                                                                                                                                                                                                                                                                                         N                   Y                         N                                                                                                                                                                                                                                                                                                             

In my mind, this output is easier to read, especially when there are hundreds or thousands of rows returned,

Hence, my question: is it possible to set these commands permanently??

Thanks

Murray Sobol
This post has been answered by Murray Sobol on Mar 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2015
Added on Mar 26 2015
#sql-developer
5 comments
1,608 views