|
Subject |
Started by |
Replies |
Views  |
Last post |
 |
 |
Can I call procedure inside a function |
kolipaka |
0 |
55 |
September 02, 2010
by kolipaka |
|
|
|
I created one package spec & body with one proc and one func |
kolipaka |
1 |
72 |
September 01, 2010
by dtech-team |
|
|
|
Export Million of records more faster |
nagaraghukiran |
1 |
310 |
July 26, 2010
by maheshparsekar |
|
|
|
Invalid cursor |
shinoda85 |
1 |
399 |
April 11, 2010
by dtech-team |
|
|
|
after getting explain plan how to tune the sql query. |
lak |
2 |
549 |
July 27, 2010
by Sun |
|
|
|
How does an Explicit cursor work? |
dtech-team |
1 |
558 |
October 07, 2009
by dtech-team |
|
|
|
Explain Implicit and Explicit cursors. |
dtech-team |
1 |
596 |
October 07, 2009
by dtech-team |
|
|
|
How to optimize shared pool in oracle |
vivekmcm |
0 |
597 |
May 29, 2009
by vivekmcm |
|
|
|
Cursor - how to use cursor attributes for implicit and explicit cursors |
dtech-team |
1 |
617 |
October 08, 2009
by dtech-team |
|
|
|
What is a Package? What are the merits/demerits of packages? |
dtech-team |
1 |
628 |
October 08, 2009
by dtech-team |
|
|
|
Hide procedure source |
Jane |
1 |
630 |
January 26, 2010
by ann |
|
|
 |
Exp utility in Oracle in 9i Versus 10g - Export views using EXPDT |
kushi |
3 |
664 |
January 07, 2010
by dtech-team |
|
|
|
How to Create type in Oracle PL/SQL Code? (Object and pass it to a procedure) |
dtech-team |
1 |
677 |
April 16, 2009
by dtech-team |
|
|
|
Difference Between %TYPE and %ROWTYPE? |
Ciciliya |
1 |
692 |
April 20, 2009
by vivekmcm |
|
|
|
Can we call a function returing boolean from a PL/SQL procedure? |
vivekmcm |
1 |
698 |
May 14, 2009
by dtech-team |
|
|
|
How to create index-by table in oracle? |
Ciciliya |
1 |
700 |
April 20, 2009
by vivekmcm |
|
|
|
Native Dynamic SQL and DBMS_SQL |
vivekmcm |
1 |
708 |
March 31, 2010
by sibanjan |
|
|
|
what is Consisent View in oracle |
vivekmcm |
1 |
729 |
May 25, 2009
by jignesh |
|
|
|
How to insert multiple records of normal table into nested table? |
Ciciliya |
1 |
732 |
May 12, 2009
by kushi |
|
|
|
Can we call a function having DML operations from SQL? |
vivekmcm |
3 |
737 |
May 15, 2009
by dtech-team |
|
|
|
how to find the line no on which error occur |
vivekmcm |
1 |
740 |
May 26, 2009
by kushi |
|
|
|
How to store the image in table? pls give example |
vivekmcm |
1 |
747 |
April 14, 2009
by kushi |
|
|
|
Interview Question- Pipelined and table functions in PL/SQL |
ashishprak |
1 |
768 |
December 10, 2009
by kushi |
|
|
|
How does an Implicit cursor work? |
dtech-team |
1 |
785 |
October 07, 2009
by dtech-team |
|
|
|
can we get the table back once the table is drop |
vivekmcm |
1 |
797 |
May 26, 2009
by kushi |
|
|
|
How the dynamic sql improve the performance explain |
vivekmcm |
1 |
804 |
May 29, 2009
by kushi |
|
|
|
In my database the values stored in one |
vivekmcm |
2 |
807 |
May 13, 2010
by shekharjchandra |
|
|
|
Packaged Procedures versus Normal Procedures |
dtech-team |
4 |
827 |
October 23, 2009
by kushi |
|
|
|
What happens to the associated trigger when a table is truncated in oracle? |
jignesh |
2 |
827 |
April 12, 2009
by kushi |
|
|
|
Interview Question- Program Overloading in PL/SQL |
ashishprak |
4 |
858 |
January 05, 2010
by jignesh |
|
|
|
can you tell me the sequence of execution of trigger |
vivekmcm |
2 |
894 |
September 10, 2009
by SalemH |
|
|
|
how to debug procedure/function/package |
vivekmcm |
1 |
895 |
March 18, 2009
by dtech-team |
|
|
|
interview Query |
vivekmcm |
1 |
935 |
May 14, 2009
by dtech-team |
|
|
|
How to move all the table from one database to another database |
vivekmcm |
1 |
943 |
March 23, 2009
by dtech-team |
|
|
|
Pragma Restrict_references .............. |
kushi |
3 |
1021 |
December 10, 2009
by dtech-team |
|
|
|
what is PRAGMA and type of pragma? and there use when we use which pragma and w |
vivekmcm |
4 |
1055 |
April 05, 2010
by sibanjan |
|
|
|
How to generate xls file from plsql procedure? |
kushi |
1 |
1105 |
January 07, 2010
by Jane |
 |
|
while running the procedure its showing an error as insufficient privileges |
kushi |
7 |
1241 |
May 09, 2010
by sibanjan |
|
|
|
How to find "current running query" in Oracle 10g? |
kushi |
3 |
1263 |
November 09, 2009
by dtech-team |
|
|
|
interview question by Tech Mahindra |
vivekmcm |
2 |
1457 |
February 19, 2010
by debrah.h48 |
|
|
|
Debug a Procedure/Fuction/package |
kushi |
7 |
1583 |
December 10, 2009
by dtech-team |
Topic you have posted in
Very Hot Topic (More than 15 replies)
Locked Topic
Sticky Topic
Poll