oracle

To get the current date/time as part of the spool file — 18-Nov-2015 14:30:12

deleting duplicates from oracle table Using self-join — 13-Oct-2015 13:10:26

Handling New line In PL SQL — 30-Mar-2012 10:04:17

Nice tutorial on connect by prior by Ivo Stoykov .. — 15-Feb-2012 10:31:45

What are RICE Components? — 16-Aug-2011 06:06:46

Retriving Oracle Database - connect descriptor parameters? (host, port, service name and SID) — 09-Feb-2011 10:15:34

How ROWNUM Works — 28-Sep-2010 09:38:06

Difference between user and schema oracle? — 28-Sep-2010 08:59:18

Bitmap Vs Btree — 28-Sep-2010 07:01:32

Oracle Analytic functions by Example — 01-Sep-2010 08:03:19

An A-Z Index of Oracle SQL Commands — 16-Jul-2010 06:56:38

Oracle Partition Decisions — 16-Jul-2010 06:47:35

Modifying Table Partitions — 16-Jul-2010 06:43:20

Partitioning in Oracle. What? Why? When? Who? Where? How? — 16-Jul-2010 06:35:50

Extracting META information from Oracle (INFORMATION_SCHEMA) — 15-Jul-2010 12:01:57

Searching on CLOB columns — 15-Jul-2010 11:46:02

Oracle SQL: remove spaces from varchar — 15-Jul-2010 11:44:11

Oracle HOW-TO: Get the Table/View Definition, Indexed Columns — 15-Jul-2010 09:39:48

Oracle/PLSQL: Oracle System Tables — 15-Jul-2010 09:24:56

Oracle New Environment Setup — 20-May-2010 13:44:01

What's blocking my lock? — 18-May-2010 09:40:26

What are the difference between DDL, DML and DCL commands? — 18-May-2010 09:27:11

Oracle autonomous transaction — 18-May-2010 09:19:26

Introduction to SQL*Loader — 18-May-2010 07:43:55

External Tables — 18-May-2010 07:25:51

Load data from a flat file into an Oracle table — 18-May-2010 07:24:52