ÿþ<html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Oracle DBA - Setting NLS Parameters </title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link href="style.css" rel="stylesheet" type="text/css"> <META NAME="description" content="This article will help in Setting NLS Parameters. Read on to know more about oracle dba . "> <META NAME="keywords" content="Global Support Architecture,Setting NLS Parameters,Choosing a Character Set,character set, oracle dba,Oracle 10g, 10g dba, oracle dba tutorial"> <script type="text/javascript" language="javascript" src="includes/sniffer.js"></script><script type="text/javascript" language="javascript1.2" src="includes/custom.js"></script><script type="text/javascript" language="javascript1.2" src="includes/style.js"></script></head> <body link = "black" topmargin=0 leftmargin=0><script type="text/javascript" language="javascript1.2" src="includes/menu.js"></script> <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct = "UA-4671442-1"; urchinTracker(); </script> <table align=left border="1" width="100%" id="table1" height="503" cellspacing="1" cellpadding="0"> <tr> <td height="60" bgcolor="E7EFE7" colspan="3" align="Left" valign="top"> <IMG SRC="learn-oracle-header/learn-oracle.jpg" WIDTH="1000" HEIGHT="91" BORDER="0" ALT="learn-oracle"> </tr> <tr> <td width="160" align="left" valign="top" bgcolor="E7EFE7" > <font face="arial" size='2'><a href="oracle_dba_step_1.html">free <B>Oracle DBA</B> tutorial</a> <font size="2" align="right"> <a href="http://oracleonline.info/oracle_jobs.html">Oracle Jobs </a><BR> <a href="http://faq.sparklit.com/main.spark?faqID=1665">Ask A Question </a><BR> <a href="http://oracleonline.info/sql_statement_tuning.html">SQL Statement Tuning </a><br> <a href="http://oracleonline.info/backup_recovery_dba.html">Backup and Recovery Concepts </a><br> <a href="http://oracleonline.info/oracle_11g_new_features.html">Oracle 11g New Features </a><br> <a href="http://oracleonline.info/oracle_e_suite_others.html">Oracle E Suite & Others </a><br> <a href="http://oracleonline.info/Oracle_data_guard_index.html">Oracle Data Guard </a><br> <a href="http://oracleonline.info/faq_for_oracle_dba.html">Oracle DBA FAQ </a><br><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR> <script type="text/javascript"><!-- google_ad_client = "pub-4228419744604469"; google_ad_width = 160; google_ad_height = 600; google_ad_format = "160x600_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "E7EFE7"; google_color_bg = "E7EFE7"; google_color_link = "0000ff"; google_color_url = "000000"; google_color_text = "000000"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <BR><BR> <B> <!--%2Chttp%3A%2F%2Fwww.sdparanormal.com%2Ff%2FParanormal_News_Feed.xml --> <!-- RSS News End --> </td> <td align="left" valign="top" bgcolor="E7EFE7" bordercolor="#99CCFF"style="border-style: solid; border-width: 1px; padding-left: 8px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px> <div id="wrapper"> <div id="body"> <div> <div> <div> <div class="inner"> <div class="indent"> <p ></B> <font face="Tahoma" size="2" color="#435C7D"> <BR><BR><BR> <h1 align="center">Setting NLS Parameters </h1><BR></font > <!-- <table> <tr> <td> --> <a href="monolingual.html">Previous Chapter </a> | <a href="checking_nls.html">Next Chapter </a><BR><BR> <!-- <IMG SRC="character-set.gif" WIDTH="599" HEIGHT="410" BORDER="0" ALT=""><BR><BR> --> <!-- </td> <td> --> <script type="text/javascript"><!-- google_ad_client = "pub-4228419744604469"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "E7EFE7"; google_color_bg = "E7EFE7"; google_color_link = "000000"; google_color_url = "000000"; google_color_text = "000000"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><p> <!-- </td> </tr> </table> --> <font face="tahoma" size="2"> NLS parameters determine the locale-specific behavior on both the client and the server. NLS parameters can be specified in the following ways: <UL> <LI>As initialization parameters on the server. You can include parameters in the initialization parameter file to specify a default session NLS environment. These settings have no effect on the client side; they control only the server's behavior.<p> For example: NLS_TERRITORY = "CZECH REPUBLIC"<p> <LI>In addition, NLS_LENGTH_SEMANTICS and NLS_CONV_EXCP can be set using the ALTER SYSTEM statement. <p> As environment variables on the client. You can use NLS parameters to specify locale-dependent behavior for the client, and also to override the default values set for the session in the initialization parameter file. For example, on a UNIX system:<p> % setenv NLS_SORT FRENCH<p> <LI>As ALTER SESSION parameters. NLS parameters that are set in an ALTER SESSION statement can be used to override the default values that are set for the session in the initialization parameter file or set by the client with environment variables.<p> ALTER SESSION SET NLS_SORT = FRENCH;<p> <LI>As SQL function parameters. NLS parameters can be used explicitly to hardcode NLS behavior within a SQL function. Doing so will override the default values that are set for the session in the initialization parameter file, set for the client with environment variables, or set for the session by the ALTER SESSION statement. For example: <p> TO_CHAR(hiredate, 'DD/MON/YYYY', 'nls_date_language = FRENCH')<p> The database character set and the national character set are specified in the CREATE DATABASE statement. <p> </UL> Following list shows the precedence order when using NLS parameters. Higher priority settings will override lower priority settings. For example, a default value will have the lowest possible priority, and can be overridden by any other method. Explicitly setting an NLS parameter within a SQL function overrides all other settings -- default, initialization parameter, environment variable, and ALTER SESSION parameters. <p> <B> Parameter Settings and Their Priorities</B> <p> <B>Highest Priority </B> <br> <UL> <LI>Explicitly set in SQL functions<br> <LI>Set by an ALTER SESSION statement<br> <LI>Set as an environment variable <br> <LI>Specified in the initialization parameter file <br> <LI>Default <br> </UL> <B>Lowest Priority </B><p> Following Table lists the NLS parameters available with the Oracle server. <p> <table width="100%" border="1" id="table1"> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <strong>Parameter</strong></font>&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <strong>Description</strong></font>&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <strong>Default</strong></font>&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <strong>Scope:</strong></font> <font face="Tahoma" size="2"><strong>I= INIT.ORA, <br> E= Environment Variable,<br> A= Alter Session</strong></font>&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_CALENDAR&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Calendar system&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Gregorian&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_COMP &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">SQL, PL/SQL operator comparison&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Binary&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_CREDIT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Credit accounting symbol&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_CURRENCY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Local currency symbol&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_DATE_FORMAT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Date format&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_DATE_LANGUAGE &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Language for day and month names&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LANGUAGE &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_DEBIT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Debit accounting symbol&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_ISO_CURRENCY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">ISO international currency symbol&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">NLS_LANG&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Language, territory, character set&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> AMERICAN_AMERICA.<br> US7ASCII &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LANGUAGE &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Language&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LANG &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, -, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LENGTH_SEMANTICS &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">How strings are treated&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Byte&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, -, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LIST_SEPARATOR &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Character separating items in a list&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_MONETARY_CHARACTERS &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Monetary symbol for dollar and cents (or their equivalents)&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_NCHAR_CONV_EXCP &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Reports data loss during a character type conversion&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">-, E, -&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_NUMERIC_CHARACTERS &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Decimal character and group separator&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_SORT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Character Sort Sequence&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LANGUAGE &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Territory&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_LANG &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, -, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TIMESTAMP_FORMAT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Timestamp&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TIMESTAMP_TZ_FORMAT &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Timestamp with Timezone&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A&nbsp;</td> </tr> <tr class="Formal" vAlign="top" align="left"> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_DUAL_CURRENCY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">Dual currency symbol&nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB"> NLS_TERRITORY &nbsp;</td> <td class="Formal"><font face="Tahoma" size="2"> <p class="TB">I, E, A</td> </tr> </table><p> <H5>Choosing a Locale with the NLS_LANG Initialization Parameter</H5> A locale is a linguistic and cultural environment in which a system or program is running. Setting the NLS_LANG parameter is the simplest way to specify locale behavior. It sets the language and territory used by the client application. It also sets the character set of the client, which is the character set of data entered or displayed by a client program.<p> The NLS_LANG parameter has three components (language, territory, and character set) in the form: <p> NLS_LANG = language_territory.charset<p> Each component controls the operation of a subset of NLS features: <p> <B>language </B> Specifies conventions such as the language used for Oracle messages, sorting, day names, and month names. Each supported language has a unique name; for example, AMERICAN, FRENCH, or GERMAN. The language argument specifies default values for the territory and character set arguments. If language is not specified, the value defaults to AMERICAN. <p> <B>territory </B> Specifies conventions such as the default date, monetary, and numeric formats. Each supported territory has a unique name; for example, AMERICA, FRANCE, or CANADA. If territory is not specified, the value defaults from the language value.<p> <B>charset</B> Specifies the character set used by the client application (normally that of the user's terminal). Each supported character set has a unique acronym, for example, US7ASCII, WE8ISO8859P1, WE8DEC, WE8EBCDIC500, or JA16EUC. Each language has a default character set associated with it.<p> The three arguments of NLS_LANG can be specified in many combinations, as in the following examples: <p> NLS_LANG = AMERICAN_AMERICA.US7ASCII<p> or <p> NLS_LANG = FRENCH_CANADA.WE8DEC<p> or <p> NLS_LANG = JAPANESE_JAPAN.JA16EUC<p> Note that illogical combinations can be set but will not work properly. For example, the following specification tries to support Japanese by using a Western European character set: <p> NLS_LANG = JAPANESE_JAPAN.WE8DEC<p> Because WE8DEC does not support any Japanese characters, you would be unable to store Japanese data. <p> <H5>Specifying NLS_LANG as an Environment Variable</H5> You can set NLS_LANG as an environment variable at the command line. For example, on UNIX, you can specify the value of NLS_LANG by entering a statement similar to the following: <p>. % setenv NLS_LANG FRENCH_FRANCE.WE8DEC<p> <H5>NLS_LANG Examples</H5> Because NLS_LANG is an environment variable, it is read by the client application at startup time. The client communicates the information defined by NLS_LANG to the server when it connects to the database server. <p> The following examples show how date and number formats are affected by the NLS_LANG parameter. % setenv NLS_LANG American_America.WE8ISO8859P1<p> <pre><font face="tahoma" size="2"> SQL> SELECT ename, hiredate, ROUND(sal/12,2) sal FROM emp; ENAME HIREDATE SAL ------- --------- ------- Clark 09-DEC-88 4195.83 Miller 23-MAR-92 4366.67 Strauß 01-APR-95 3795.87 </font></pre><p> If NLS_LANG is set with the language as French, the territory as France, and the character set as Western European 8-bit ISO 8859-1, then the same query returns the following information: <p> % setenv NLS_LANG French_France.WE8ISO8859P1<p> <pre><font face="tahoma" size="2"> SQL> SELECT ename, hiredate, ROUND(sal/12,2) sal FROM emp; ENAME HIREDATE SAL --------- --------- ------- Clark 09/12/88 4195,83 Miller 23/03/92 4366,67 Strauß 01/04/95 3795,87 </font></pre> <H5>Overriding Language and Territory Specifications</H5> The NLS_LANG parameter sets the language and territory environment used by both the server session (for example, SQL command execution) and the client application (for example, display formatting in Oracle tools). Using this parameter ensures that the language environments of both database and client application are automatically the same. <p> The language and territory components of the NLS_LANG parameter set the default values for the other NLS parameters, such as date format, numeric characters, and linguistic sorting. Each of these detailed parameters can be set in the client environment to customize the language and territory values. <p> Note that NLS parameters in the client environment are ignored if NLS_LANG is not set. <p> If the NLS_LANG parameter is not set, the server session environment remains initialized with values of NLS_LANGUAGE, NLS_TERRRITORY, and other NLS instance parameters from the initialization parameter file. You can modify these parameters and restart the instance to change the defaults. <p> You might want to modify your NLS environment dynamically during the session. To do so, you can use NLS_LANGUAGE, NLS_TERRITORY and other NLS parameters in the ALTER SESSION statement. <p> The ALTER SESSION statement modifies only the session environment. The local client NLS environment is not modified, unless the client explicitly retrieves the new settings and modifies its local environment. SQL*Plus is an example of an application that retrieves new settings; Oracle Developer is an example of an application that does not retrieve new settings. <p> <H5>NLS Database Parameters</H5> When a new database is created during the execution of CREATE DATABASE statement, the NLS database environment is established. The current NLS instance parameters, as defined by the initialization parameter file, are stored in the data dictionary along with the database and national character sets. <p> <script type="text/javascript"><!-- google_ad_client = "pub-4228419744604469"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "E7EFE7"; google_color_bg = "E7EFE7"; google_color_link = "000000"; google_color_url = "000000"; google_color_text = "000000"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <p> <a href="monolingual.html">Previous Chapter </a> | <a href="checking_nls.html">Next Chapter </a><BR><BR> </font> </b><font face="tahoma" size="2"> <P> <A HREF="http://oracleonline.info"> <B>More Tutorials on Oracle dba ...</B></FONT></A> <BR> <BR> Source :Oracle Documentation</a> <BR><BR> <!-- Social Bookmarking code starts here --> <!-- * Social Bookmark Script * @ Version 1.9 * @ Copyright (C) 2006-2008 by Alexander Hadj Hassine - All rights reserved * @ Website http://www.social-bookmark-script.com/ * @ * @ By using our script <b> Oracle DBA </b> must leave our copyright notices and the links * @ in the script untouched. The links doesn't be removed, converted, hidden * @ or made invisible. If <b> Oracle DBA </b> set a backlink to http://www.social bookmark script.com/ * @ (at least 1 time "search machines friendly" from the starting side of your web page) * @ <b> Oracle DBA </b> can be adapt the script to <b> Oracle DBA </b> for your purpose changes. --> <a target="_blank" style="text-decoration:none; font-size:11px; font-family:Arial; color: #2A4956;" href="http://www.social-bookmark-script.com/">Liked it ? Want to share it ? Social Bookmarking</a><br> <div style="border-top-style:solid; padding-top:3px; border-top-width: 1px; border-top-color: #2A4956; float: left;"> <script language="JavaScript" type="text/JavaScript"> <!-- function Social_Load() { var d=document; if(d.images){ if(!d.Social) d.Social=new Array(); var i,j=d.Social.length,a=Social_Load.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.Social[j]=new Image; d.Social[j++].src=a[i];}} } Social_Load('http://www.social-bookmark-script.de/img/bookmarks/wong_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/boni_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/newsider_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/digg_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/del_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/reddit_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/jumptags_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/stumbleupon_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/slashdot_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/netscape_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/furl_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/yahoo_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/spurl_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/google_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/blinklist_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/technorati_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/newsvine_trans_ani.gif','http://www.social-bookmark-script.de/img/bookmarks/what_trans_ani.gif','http://www.social-bookmark-script.de/load.gif') function schnipp() { var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function schnupp(n, d) { var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=schnupp(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function schnapp() { var i,j=0,x,a=schnapp.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=schnupp(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <a rel="nofollow" style="text-decoration:none;" href="http://www.mister-wong.de/" onclick="window.open('http://www.mister-wong.de/index.php?action=addurl&amp;bm_url='+encodeURIComponent(location.href)+'&amp;bm_notice=&amp;bm_description='+encodeURIComponent(document.title)+'&amp;bm_tags=');return false;" title="Add to: Mr. Wong" onmouseover="schnapp('wong','','http://www.social-bookmark-script.de/img/bookmarks/wong_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/wong_trans.gif" alt="Add to: Mr. Wong" name="wong" border="0" id="wong"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.bonitrust.de/" onclick="window.open('http://www.bonitrust.de/account/bookmark/?bookmark_url='+ unescape(location.href));return false;" title="Add to: BoniTrust" onmouseover="schnapp('Boni','','http://www.social-bookmark-script.de/img/bookmarks/boni_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/boni_trans.gif" alt="Add to: BoniTrust" name="Boni" border="0" id="Boni"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.newsider.de/" onclick="window.open('http://www.newsider.de/submit.php?url='+(document.location.href));return false;" title="Add to: Newsider" onmouseover="schnapp('Newsider','','http://www.social-bookmark-script.de/img/bookmarks/newsider_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/newsider_trans.gif" alt="Add to: Newsider" name="Newsider" border="0" id="Newsider"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://digg.com/" onclick="window.open('http://digg.com/submit?phase=2&amp;url='+encodeURIComponent(location.href)+'&amp;bodytext=&amp;tags=&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Digg" onmouseover="schnapp('Digg','','http://www.social-bookmark-script.de/img/bookmarks/digg_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/digg_trans.gif" alt="Add to: Digg" name="Digg" border="0" id="Digg"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://del.icio.us/" onclick="window.open('http://del.icio.us/post?v=2&amp;url='+encodeURIComponent(location.href)+'&amp;notes=&amp;tags=&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Del.icio.us" onmouseover="schnapp('Delicious','','http://www.social-bookmark-script.de/img/bookmarks/del_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/del_trans.gif" alt="Add to: Del.icio.us" name="Delicious" border="0" id="Delicious"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://reddit.com/" onclick="window.open('http://reddit.com/submit?url='+encodeURIComponent(location.href)+'&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Reddit" onmouseover="schnapp('Reddit','','http://www.social-bookmark-script.de/img/bookmarks/reddit_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/reddit_trans.gif" alt="Add to: Reddit" name="Reddit" border="0" id="Reddit"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.jumptags.com/" onclick="window.open('http://www.jumptags.com/add/?url='+encodeURIComponent(location.href)+'&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Jumptags" onmouseover="schnapp('Jumptags','','http://www.social-bookmark-script.de/img/bookmarks/jumptags_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/jumptags_trans.gif" alt="Add to: Jumptags" name="Jumptags" border="0" id="Jumptags"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.stumbleupon.com/" onclick="window.open('http://www.stumbleupon.com/submit?url='+encodeURIComponent(location.href)+'&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: StumbleUpon" onmouseover="schnapp('StumbleUpon','','http://www.social-bookmark-script.de/img/bookmarks/stumbleupon_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/stumbleupon_trans.gif" alt="Add to: StumbleUpon" name="StumbleUpon" border="0" id="StumbleUpon"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://slashdot.org/" onclick="window.open('http://slashdot.org/bookmark.pl?url='+encodeURIComponent(location.href)+'&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Slashdot" onmouseover="schnapp('Slashdot','','http://www.social-bookmark-script.de/img/bookmarks/slashdot_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/slashdot_trans.gif" alt="Add to: Slashdot" name="Slashdot" border="0" id="Slashdot"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.netscape.com/" onclick="window.open('http://www.netscape.com/submit/?U='+encodeURIComponent(location.href)+'&amp;T='+encodeURIComponent(document.title));return false;" title="Add to: Netscape" onmouseover="schnapp('Netscape','','http://www.social-bookmark-script.de/img/bookmarks/netscape_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/netscape_trans.gif" alt="Add to: Netscape" name="Netscape" border="0" id="Netscape"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.furl.net/" onclick="window.open('http://www.furl.net/storeIt.jsp?u='+encodeURIComponent(location.href)+'&amp;keywords=&amp;t='+encodeURIComponent(document.title));return false;" title="Add to: Furl" onmouseover="schnapp('Furl','','http://www.social-bookmark-script.de/img/bookmarks/furl_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/furl_trans.gif" alt="Add to: Furl" name="Furl" border="0" id="Furl"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.yahoo.com/" onclick="window.open('http://myweb2.search.yahoo.com/myresults/bookmarklet?t='+encodeURIComponent(document.title)+'&amp;d=&amp;tag=&amp;u='+encodeURIComponent(location.href));return false;" title="Add to: Yahoo" onmouseover="schnapp('Yahoo','','http://www.social-bookmark-script.de/img/bookmarks/yahoo_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/yahoo_trans.gif" alt="Add to: Yahoo" name="Yahoo" border="0" id="Yahoo"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.spurl.net/" onclick="window.open('http://www.spurl.net/spurl.php?v=3&amp;tags=&amp;title='+encodeURIComponent(document.title)+'&amp;url='+encodeURIComponent(document.location.href));return false;" title="Add to: Spurl" onmouseover="schnapp('Spurl','','http://www.social-bookmark-script.de/img/bookmarks/spurl_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/spurl_trans.gif" alt="Add to: Spurl" name="Spurl" border="0" id="Spurl"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.google.com/" onclick="window.open('http://www.google.com/bookmarks/mark?op=add&amp;hl=de&amp;bkmk='+encodeURIComponent(location.href)+'&amp;annotation=&amp;labels=&amp;title='+encodeURIComponent(document.title));return false;" title="Add to: Google" onmouseover="schnapp('Google','','http://www.social-bookmark-script.de/img/bookmarks/google_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/google_trans.gif" alt="Add to: Google" name="Google" border="0" id="Google"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.blinklist.com/" onclick="window.open('http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Description=&amp;Tag=&amp;Url='+encodeURIComponent(location.href)+'&amp;Title='+encodeURIComponent(document.title));return false;" title="Add to: Blinklist" onmouseover="schnapp('Blinklist','','http://www.social-bookmark-script.de/img/bookmarks/blinklist_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/blinklist_trans.gif" alt="Add to: Blinklist" name="Blinklist" border="0" id="Blinklist"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.technorati.com/" onclick="window.open('http://technorati.com/faves?add='+encodeURIComponent(location.href)+'&amp;tag=');return false;" title="Add to: Technorati" onmouseover="schnapp('Technorati','','http://www.social-bookmark-script.de/img/bookmarks/technorati_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/technorati_trans.gif" alt="Add to: Technorati" name="Technorati" border="0" id="Technorati"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://www.newsvine.com/" onclick="window.open('http://www.newsvine.com/_wine/save?popoff=1&amp;u='+encodeURIComponent(location.href)+'&amp;tags=&amp;blurb='+encodeURIComponent(document.title));return false;" title="Add to: Newsvine" onmouseover="schnapp('Newsvine','','http://www.social-bookmark-script.de/img/bookmarks/newsvine_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/newsvine_trans.gif" alt="Add to: Newsvine" name="Newsvine" border="0" id="Newsvine"> </a> <a rel="nofollow" style="text-decoration:none;" href="http://en.wikipedia.org/wiki/Social_bookmarking" target="" title="Information" onmouseover="schnapp('Information','','http://www.social-bookmark-script.de/img/bookmarks/what_trans_ani.gif',1)" onmouseout="schnipp()" > <img style="padding-bottom:1px;" src="http://www.social-bookmark-script.de/img/bookmarks/what_trans.gif" alt="Information" name="Information" border="0" id="Information"> </a> </div> <!-- Social Bookmarking code ends here --> <BR><BR> <BR><BR> <p align="center"> <font face="Tahoma" size="2">Want to share or request <B>Oracle Tutorial</B> articles to become a <B>Oracle DBA</B>. Direct your requests to<a href="mailto:webmaster@oracleonline.info" alt='Learn oracle sql plan'> webmaster@oracleonline.info</a></font></p> </td> </tr> </table> </div> </div> </div> </div> </div> </div> </div> </th> </tr> </table> </body> </html>