ORACLE FUNCTIONS----http://www.psoug.org/reference/functions.html MISCELENOUS---------http://www.psoug.org/library.html PROCEDURES----------http://www.psoug.org/reference/procedures.html PACKAGES------------http://www.psoug.org/reference/packages.html PIPENINED-FUNCTIONS-http://www.psoug.org/reference/pipelined.html METADATA------------http://www.psoug.org/reference/dbms_metadata.html AUTONOMOUS-TRANSACTION---http://www.psoug.org/reference/autonomous_tx.html OTHERS LINKS--------http://www.databasejournal.com/features/article.php/3593471 POSTGRES SQL--------http://www.postgresql.org/docs/7.4/interactive/sql-commands.html ORACLE--------------http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm DATABASE CREATION-1-http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/create.htm DATABASE CREATION-2-http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html DATABASE CREATION-3-http://download-east.oracle.com/docs/cd/B19306_01/win.102/b14304/create.htm DATABASE CREATION-4-http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a67772/create.htm SELECT case when ename LIKE 'SC%' then ename else '0' end AS empname FROM emp ORACLE FORUM--------http://forums.oracle.com/forums/forum.jspa?forumID=64 ODP1-----------------http://www.oracle.com/technology/tech/windows/odpnet/faq.html ODP2-----------------http://www.oracle.com/technology/software/tech/windows/odpnet/install10104.html FORMS----------------http://www.oracle.com/technology/documentation/forms.html DYNAMIC SAMPLING-----http://www.dba-oracle.com/art_dbazine_oracle10g_dynamic_sampling_hint.htm HINTS----------------http://www.oradev.com/hints.jsp INSTALING ORACLE ON REDHAT1--http://www.oracle-base.com/articles/9i/Oracle9iInstallationOnRedHatAS4AndCentos4.php INSTALING ORACLE ON REDHAT2--http://www.puschitz.com/InstallingOracle9i.shtml EXISTS---------------http://www.thescripts.com/forum/thread64104.html NLS_PARAMTERS--------http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm RULE BASED OPTIMIZER-http://www.psoug.org/reference/rbo.html DDLTRIGGERS1---------http://www.dba-oracle.com/t_ddl_triggers.htm DDLTRIGGERS2---------http://www.psoug.org/reference/ddl_trigger.html partition------------http://www.oracle-base.com/articles/8i/PartitionedTablesAndIndexes.php reports--------------http://www.oracle.com/technology/documentation/reports.html matrix report---------------http://www.oracle.com/webapps/online-help/reports/10.1.2/state/content/navId.3/navSetId._/vtTopicFile.htmlhelp_rwbuild_hs%7Crwwhthow%7Cwhatare%7Creports%7Ca_nested_matrix_reports~htm/ Database link from Oracle to SQL Server link1-----http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm Database link from Oracle to SQL Server link2-----http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1 DATABASE LIMIT-------http://oracle.cs.uoi.gr/enterprise_server/server.815/a67790/ch4.htm oreilly--------------http://www.oreillynet.com/pub/a/network/2003/04/22/feuerstein.html SQL*LOADER-----------http://www.oracle.com/technology/oramag/oracle/04-mar/o24tech_data.html SQL*LOADER-----------http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html triggers-------------http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#786 mutating triggers----http://asktom.oracle.com/tkyte/Mutate/index.html INDEXES--------------http://www.techonthenet.com/oracle/indexes.php INDEXES--------------http://www.dba-oracle.com/art_9i_indexing.htm INDEXES--------------http://asktom.oracle.com/tkyte/article1/index.html SDO_GEOMETRY Object Type Methods----http://download.oracle.com/docs/html/A88805_01/sdo_meth.htm SDO_GEOMETRY Object Type Methods----http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10826/sdo_meth.htm