Hello all,  Why is Normalization is really needed.  What is the exact use of it? As sometimes not all programmers do the Normalization Process. ...
what is bulk sql? there is lots of process run in single sql script. actually i didn't understand this could you please clear what you looking for. If the...
Hello All, The same doubt I have? I have been asked this in an Interview? Thanks and Regards, Prachi prachi ... From: nive_sha2002 <nive_sha2002@...> ...
1. Three users at a time giving the following command: alter database backup controlfile to trace; How differentiate the file using the filename itself? 2....
. How we find out from the RMAN catalog if a particular archive log has been backed-up? How we configure SGA for a mid-sized OLTP environment? • What is...
... Whenever you run any procedures or functions or any other application or transaction either database level or application level you get the following...
ORA-00903: Oracle Database Reserved Words <http://arjudba.blogspot.com/2008/06/ora-00903-oracle-database-reserved.\ html> I will start this post with some...
Oracle Built in Datatypes <http://arjudba.blogspot.com/2008/06/oracle-built-in-datatypes.html> Each column in a table/ index or each argument in a function/...
Visit http://arjudba.blogspot.com/2008/04/types-of-metadata-views-in-oracle-10g.html Types of Metadata Views in Oracle 10g Metadata indicates data about the...
LONG Datatype in Oracle •Before going into detail oracle strongly recommend not to use LONG datatype in oracle. LONG datatype is remained for backward ...
Schema Object Naming Rules <http://arjudba.blogspot.com/2008/07/schema-object-naming-rules.html> In order to know the schema objects please have a look at ...
LONG Datatype in Oracle <http://arjudba.blogspot.com/2008/06/long-datatype-in-oracle.html> •Before going into detail oracle strongly recommend not to use...
New Feature of 10.2g: Eliminate Control File Re-Creation <http://arjudba.blogspot.com/2008/04/new-feature-of-102g-eliminate-contr\ ol.html> Before Oracle...
Schema Object Naming Rules In order to know the schema objects please have a look at http://arjudba.blogspot.com/2008/06/database-objects-in-oracle.html There...
Creating Multiple Tables and Views in a Single Operation Sometimes you may need to do several ddl statements in a database.Suppose in a file you have list of...
New Feature of 10.2g: Eliminate Control File Re-Creation Before Oracle 10.2g if we need to change the limit of MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY,...
What is the difference between @ and @@ in Sql*plus? From Sql*plus we can execute any script with START command. @ is similar to START. If you write...
Null value Concept in Oracle •A column in a row contains Null value in oracle is treated as special one which indicates the column in that row contains no...
ORA-01756: quoted string not properly terminated ... Single quote within a string data type like CHAR, VARCHAR2, NVARCHAR etc. will end up during runtime with...
  Hello All,  Do anybody have any idea abt following queries? 1> if i put same trigger at different level which one will get executed first ?  2> how...
Hello All, Â Do anybody have any idea? Â 1> How many anonymous blocks can U write within a Stored Procedure? Is there any restrictions? Â 2> What is the...
if i put same trigger at different level which one will get executed first ? It is depands on trigger event. how to change its firing order ? Through recreate...
How many anonymous blocks can U write within a Stored Procedure? ... AFAIK, no there is not limit. ... procedures/functions? No difference with functionality ,...
... connect with RMAN session and query RMAN> list backup; ... We can imagine SGA configuration with starting. we can startup with minimum size and after...
... Control trace file is created in UDUMP directory. with the following name convensation. SID_ORA_NNN.TRC three user is execute the same command at same time...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
