Focus on Windows 2000/NT

Recent Answers

2013-05-17 Oracle - Executing a formulae which is in a field:

Hi Natraj,    To execute a stored procedure from within Oracle's SQLPLUS, you can either use:    SQL> execute my_store_proc (var1, var2, ... var x)    where var1, var2 ... var x dependes on the number

2013-05-14 Oracle - dynamic queries:

Hi Josh,    Here's a re-write of your code in question:    select   A.errormessage          , A.main_count          , B.onetwoone_count  from     (select C.errormessage, count(C.errormessage) main_count

2013-05-12 Oracle - Oracle DBA:

Hi Prashant,    First and foremost, you must have a very strong understanding of the concepts and practical proficiency with Oracle SQL (including PL/SQL). It's not just about writing queries but also

2013-05-11 Oracle - about oracle:

Hello Prashant,    Oracle DBA is a good area. But first you have to learn the basics of Oracle, SQL, PL/SQL etc.    Once you get the oracle concepts, you can go ahead with some dba activities, gain experience

2013-05-06 Oracle - PL/SQL:

Good day Gaurav    1)In what case hint is helping and in what case it is reducing the performance for a query?  There are scenarios that Oracle optimizer did not create the optimal execution path to retrieve