|
Subject |
Started by |
Replies |
Views |
Last post  |
 |
 |
after getting explain plan how to tune the sql query. |
lak |
2 |
381 |
July 27, 2010
by Sun |
|
|
|
Export Million of records more faster |
nagaraghukiran |
1 |
207 |
July 26, 2010
by maheshparsekar |
|
|
|
In my database the values stored in one |
vivekmcm |
2 |
753 |
May 13, 2010
by shekharjchandra |
 |
|
while running the procedure its showing an error as insufficient privileges |
kushi |
7 |
1186 |
May 09, 2010
by sibanjan |
|
|
|
Invalid cursor |
shinoda85 |
1 |
350 |
April 11, 2010
by dtech-team |
|
|
|
what is PRAGMA and type of pragma? and there use when we use which pragma and w |
vivekmcm |
4 |
997 |
April 05, 2010
by sibanjan |
|
|
|
Native Dynamic SQL and DBMS_SQL |
vivekmcm |
1 |
658 |
March 31, 2010
by sibanjan |
|
|
|
interview question by Tech Mahindra |
vivekmcm |
2 |
1383 |
February 19, 2010
by debrah.h48 |
|
|
|
Hide procedure source |
Jane |
1 |
581 |
January 26, 2010
by ann |
|
|
|
How to generate xls file from plsql procedure? |
kushi |
1 |
1056 |
January 07, 2010
by Jane |
|
|
 |
Exp utility in Oracle in 9i Versus 10g - Export views using EXPDT |
kushi |
3 |
629 |
January 07, 2010
by dtech-team |
|
|
|
Interview Question- Program Overloading in PL/SQL |
ashishprak |
4 |
810 |
January 05, 2010
by jignesh |
|
|
|
Interview Question- Pipelined and table functions in PL/SQL |
ashishprak |
1 |
728 |
December 10, 2009
by kushi |
|
|
|
Pragma Restrict_references .............. |
kushi |
3 |
981 |
December 10, 2009
by dtech-team |
|
|
|
Debug a Procedure/Fuction/package |
kushi |
7 |
1513 |
December 10, 2009
by dtech-team |
|
|
|
How to find "current running query" in Oracle 10g? |
kushi |
3 |
1216 |
November 09, 2009
by dtech-team |
|
|
|
Packaged Procedures versus Normal Procedures |
dtech-team |
4 |
798 |
October 23, 2009
by kushi |
|
|
|
Cursor - how to use cursor attributes for implicit and explicit cursors |
dtech-team |
1 |
586 |
October 08, 2009
by dtech-team |
|
|
|
What is a Package? What are the merits/demerits of packages? |
dtech-team |
1 |
589 |
October 08, 2009
by dtech-team |
|
|
|
How does an Implicit cursor work? |
dtech-team |
1 |
740 |
October 07, 2009
by dtech-team |
|
|
|
How does an Explicit cursor work? |
dtech-team |
1 |
526 |
October 07, 2009
by dtech-team |
|
|
|
Explain Implicit and Explicit cursors. |
dtech-team |
1 |
561 |
October 07, 2009
by dtech-team |
|
|
|
can you tell me the sequence of execution of trigger |
vivekmcm |
2 |
857 |
September 10, 2009
by SalemH |
|
|
|
How the dynamic sql improve the performance explain |
vivekmcm |
1 |
772 |
May 29, 2009
by kushi |
|
|
|
How to optimize shared pool in oracle |
vivekmcm |
0 |
569 |
May 29, 2009
by vivekmcm |
|
|
|
can we get the table back once the table is drop |
vivekmcm |
1 |
774 |
May 26, 2009
by kushi |
|
|
|
how to find the line no on which error occur |
vivekmcm |
1 |
713 |
May 26, 2009
by kushi |
|
|
|
what is Consisent View in oracle |
vivekmcm |
1 |
697 |
May 25, 2009
by jignesh |
|
|
|
Can we call a function having DML operations from SQL? |
vivekmcm |
3 |
703 |
May 15, 2009
by dtech-team |
|
|
|
Can we call a function returing boolean from a PL/SQL procedure? |
vivekmcm |
1 |
668 |
May 14, 2009
by dtech-team |
|
|
|
interview Query |
vivekmcm |
1 |
891 |
May 14, 2009
by dtech-team |
|
|
|
How to insert multiple records of normal table into nested table? |
Ciciliya |
1 |
679 |
May 12, 2009
by kushi |
|
|
|
How to create index-by table in oracle? |
Ciciliya |
1 |
661 |
April 20, 2009
by vivekmcm |
|
|
|
Difference Between %TYPE and %ROWTYPE? |
Ciciliya |
1 |
652 |
April 20, 2009
by vivekmcm |
|
|
|
How to Create type in Oracle PL/SQL Code? (Object and pass it to a procedure) |
dtech-team |
1 |
644 |
April 16, 2009
by dtech-team |
|
|
|
How to store the image in table? pls give example |
vivekmcm |
1 |
710 |
April 14, 2009
by kushi |
|
|
|
What happens to the associated trigger when a table is truncated in oracle? |
jignesh |
2 |
792 |
April 12, 2009
by kushi |
|
|
|
How to move all the table from one database to another database |
vivekmcm |
1 |
899 |
March 23, 2009
by dtech-team |
|
|
|
how to debug procedure/function/package |
vivekmcm |
1 |
851 |
March 18, 2009
by dtech-team |
Topic you have posted in
Very Hot Topic (More than 15 replies)
Locked Topic
Sticky Topic
Poll