-
-
What is the difference between DSS and OLPT
kodaliprakash
- Sep 7th, 2007
DSS is desicion support system. This is mainly useful for tking appropriate decisions based on existing data. All the data is already available in the DB. And we have to get reports according to the n...
-
What is the Life of an SQL Statement?
sreekumar_nair_it
- Mar 27th, 2008
Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse S...
fancyoracle
- Aug 16th, 2007
Once parsed, the SQL statement is available in the memory till the session is valid.
-
How can I Export 9i data in 8 ? I mean when I Export from 9i and Import in 8, I face errors. what sould I do and my pc is not in Network.
narendra05
- Apr 23rd, 2010
I would suggest create a db link in Oracle 8 to Oracle 9i and run the CREATE TABLE AS SELECT FROM another database.I would suggest you move to Oracle 10g /11g soon as Oracle support is already stopped to 9i and 8i release.Narendra
sanjayoracle
- Apr 25th, 2008
We can do it. but first we have to confirm that parameter NLS_LANG is same in both database. otherwise in IMP process oracle will give error
-
Oracle8i and Oracle9i.
Difference between oracle8i and oracle9i.
Zeeshan
- Aug 3rd, 2007
SGA: System Global Area. Its a chuck of memory used on oracle processes.
