ASP.NET Web PDF Document Viewer/Editor Control Library

The site profile is created during installation, and the file is placed in the $ORACLE_HOME/ sqlplus/admin directory. Listing 12-4 shows the default glogin.sql file, which is read by Oracle every time you log in to SQL*Plus. You can modify this default file to suit your needs. Listing 12-4. The Default glogin.sql File -- Copyright (c) 1988, 2003, Oracle Corporation. All Rights Reserved. -- NAME -glogin.sql -- DESCRIPTION -SQL*Plus global login "site profile" file -Add any SQL*Plus commands here that are to be executed when a -user starts SQL*Plus, or uses the SQL*Plus CONNECT command -- USAGE -This script is automatically run -- Used by Trusted Oracle COLUMN ROWLABEL FORMAT A15 -- Used for the SHOW ERRORS command COLUMN LINE/COL FORMAT A8 COLUMN ERROR FORMAT A65 WORD_WRAPPED -- Used for the SHOW SGA command COLUMN name_col_plus_show_sga FORMAT a24 COLUMN units_col_plus_show_sga FORMAT a15 -- Defaults for SHOW PARAMETERS COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE -- Defaults for SHOW RECYCLEBIN COLUMN origname_plus_show_recyc FORMAT a16 HEADING 'ORIGINAL NAME' COLUMN objectname_plus_show_recyc FORMAT a30 HEADING 'RECYCLEBIN NAME' COLUMN objtype_plus_show_recyc FORMAT a12 HEADING 'OBJECT TYPE' COLUMN droptime_plus_show_recyc FORMAT a19 HEADING 'DROP TIME' -- Defaults for SET AUTOTRACE EXPLAIN report COLUMN id_plus_exp FORMAT 990 HEADING i COLUMN parent_id_plus_exp FORMAT 990 HEADING p COLUMN plan_plus_exp FORMAT a60 COLUMN object_node_plus_exp FORMAT a8 COLUMN other_tag_plus_exp FORMAT a29 COLUMN other_plus_exp FORMAT a44

excel barcode erstellen freeware, excel barcode generator formula, create barcode in excel 2013, excel barcode generator free, active barcode excel 2013 download, using barcode in excel 2010, microsoft excel 2003 barcode font, how to create barcode in excel 2010, barcode add-in for word and excel 2010, excel barcode inventory macro,

If individual users wish to set their own particular preferences for variables for their sessions, they can use the login.sql file, another file checked by Oracle, to set their own customized SQL*Plus environment. Because the login.sql file lets you set individual user variables, it is also known as the user profile file. The commands in the login.sql file are executed automatically when you connect to SQL*Plus.

print_tree () { id=$1 echo "$2$id \c" eval echo \"'$owner'$id '$command'$id\"

This file is usually located in your home directory. You can use the login.sql file for both SQL*Plus command-line and Windows GUI connections. Note that the iSQL*Plus environment can t be configured with the login.sql file it applies only to SQL*Plus. Listing 12-5 shows a sample login.sql file. Listing 12-5. A Sample login.sql File -login.sql -SQL*Plus user login startup file. -This script is automatically run after glogin.sql -To change the SQL*Plus prompt to display the current user, -connection identifier and current time. -- First set the database date format to show the time. ALTER SESSION SET nls_date_format = 'HH:MI:SS'; -- SET the SQLPROMPT to include the _USER, _CONNECT_IDENTIFIER -- and _DATE variables. SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER _DATE> " -- To set the number of lines to display in a report page to 24. SET PAGESIZE 24 -- To set the number of characters to display on each report line to 78. SET LINESIZE 78 -- To set the number format used in a report to $99,999. SET NUMFORMAT $99,999

Note When you connect to the database using SQL*Plus, the site profile, glogin.sql, is executed first, followed by the site profile script, the login.sql file. All SQL*Plus variable values you specify in the login.sql file will override the settings in the glogin.sql file. Any changes you make in the session itself will override everything else and last for the duration of that session only.

Native Class from Same Assembly with Native Member Functions Native Class from Imported DLL with Managed Member Functions Native Class from Imported DLL with Native Member Functions

The glogin.sql file, which contains system-wide settings, takes effect after you log in successfully through a SQLPLUS or CONNECT command. It also comes into effect when you use the /NOLOG option when you connect to SQL*Plus and when you connect successfully from an iSQL*Plus session or when you use the CONNECT command from within an iSQL*Plus session to connect to a database. The login.sql file, which is applicable only to the individual user s session, is automatically run right after the site profile file, glogin.sql, is run. Note that the login.sql file has no relevance in the iSQL*Plus interface.

As you saw earlier in this chapter, you can start a new SQL*Plus session by merely typing sqlplus at the command prompt. However, you can specify several command-line options to customize the SQL*Plus session. Listing 12-6 shows how you can find all the command-line options available to you in SQL*Plus. Listing 12-6. SQL*Plus Command-Line Options [pasprod] $ sqlplus -help SQL*Plus: Release 10.2.0.0.0 - Beta Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]

The \c instructs the first echo command not to perform a carriage return after the output. The output of the subsequent echo of the owner and command variables completes the output.