|
Subject |
Started by |
Replies |
Views |
Last post  |
 |
 |
Write a query to display output like- |
dearcyril |
3 |
158 |
July 28, 2010 by chandramohan207 |
 |
 |
Can any body explain me why we use like IS/AS keyword while creating package. |
lakshmanraok |
3 |
126 |
July 26, 2010 by Haarika.va |
 |
 |
Diff b/w materialized views and normal views |
Haarika.va |
4 |
177 |
July 23, 2010 by dtech-team |
 |
 |
How we r using instead of trigger..... |
Haarika.va |
2 |
110 |
July 22, 2010 by lakshmanraok |
 |
 |
Can anyone tell me about "BULK_BINDING? |
Haarika.va |
1 |
94 |
July 22, 2010 by lakshmanraok |
 |
 |
"Create or Replace"??? |
avinash |
3 |
125 |
July 07, 2010 by sibanjan |
 |
 |
Which are the different classification of Triggers? / How many type of triggers? |
dtech-team |
2 |
896 |
July 06, 2010 by avinash |
 |
 |
Finding the list of procedures .... |
dearcyril |
1 |
320 |
June 01, 2010 by sibanjan |
 |
 |
How to submit Concurrent Program from back end |
karthik |
3 |
239 |
May 31, 2010 by vivekmcm |
 |
 |
where i will get best sql and pl/sql notes |
karthik |
1 |
230 |
May 28, 2010 by sibanjan |
 |
 |
how to get no of outputs using function |
karthik |
1 |
186 |
May 28, 2010 by sibanjan |
 |
 |
what is the Explan plan in oracle how it will work give me example on emp |
karthik |
1 |
198 |
May 26, 2010 by sibanjan |
 |
 |
Storing records in to a variable declared as a nested table |
dearcyril |
2 |
217 |
May 14, 2010 by dearcyril |
 |
 |
Creating index of Materialized views |
dearcyril |
2 |
234 |
May 12, 2010 by dearcyril |
 |
 |
What do you mean by number(10,-2)? |
vivekmcm |
1 |
201 |
May 12, 2010 by dtech-team |
 |
 |
Table size in Oracle |
medasanibabu |
3 |
309 |
May 04, 2010 by dtech-team |
 |
 |
Query on formatting data in a specific way in Oracle |
andhibis |
2 |
191 |
April 26, 2010 by dtech-team |
 |
 |
What is execution plan? |
dtech-team |
1 |
242 |
April 25, 2010 by sibanjan |
 |
 |
Parametrized cursor |
punitgupta23 |
1 |
277 |
April 11, 2010 by sibanjan |
 |
 |
HIGHER WATERMARK Level of the table |
sibanjan |
1 |
235 |
March 31, 2010 by dtech-team |
 |
 |
OCA question |
vivekmcm |
2 |
229 |
March 30, 2010 by sibanjan |
 |
 |
OCA question |
vivekmcm |
1 |
147 |
March 30, 2010 by sibanjan |
 |
 |
interview question |
vivekmcm |
1 |
292 |
March 30, 2010 by kushi |
 |
 |
Interview question |
vivekmcm |
1 |
205 |
March 30, 2010 by kushi |
 |
 |
What is the purpose of database links in Oracle? |
dtech-team |
3 |
236 |
March 30, 2010 by vivekmcm |
 |
 |
What is the difference between a SYNONYM and a VIEW ? |
dtech-team |
1 |
275 |
March 29, 2010 by sibanjan |
 |
 |
when to use Integrity Constraints and when to use database triggers ? |
ashishprak |
2 |
285 |
March 29, 2010 by sibanjan |
 |
 |
Can anybody tell me instead of trigger fires before or after the DML |
vivekmcm |
1 |
242 |
March 29, 2010 by sibanjan |
 |
 |
What is the difference between %TYPE and %ROWTYPE? |
dtech-team |
1 |
218 |
March 29, 2010 by sibanjan |
 |
 |
Define Referential Integrity. |
dtech-team |
0 |
168 |
March 28, 2010 by dtech-team |
 |
 |
How do you estimate space required by Clusters? |
dtech-team |
0 |
108 |
March 28, 2010 by dtech-team |
 |
 |
How do you allocate space for Indexes? |
dtech-team |
0 |
130 |
March 28, 2010 by dtech-team |
 |
 |
Need the help at the earliest |
srikant |
1 |
172 |
March 26, 2010 by kushi |
 |
 |
What is a mutating and constraining table? |
dtech-team |
1 |
207 |
March 23, 2010 by ashishprak |
 |
 |
What are the pros and cons of using triggers? |
dtech-team |
0 |
170 |
March 20, 2010 by dtech-team |
 |
 |
What is the difference of a LEFT JOIN and an INNER JOIN statement? |
dtech-team |
0 |
176 |
March 20, 2010 by dtech-team |
 |
 |
How can you enable a trace for a session? |
dtech-team |
0 |
154 |
March 20, 2010 by dtech-team |
 |
 |
What are pseudo columns? Name some of them! |
dtech-team |
0 |
135 |
March 20, 2010 by dtech-team |
 |
 |
Can any body expalin me how the give query work |
vivekmcm |
1 |
188 |
March 19, 2010 by kushi |
 |
 |
can any tell me about query optimization with examples..? |
rameshrevella |
2 |
348 |
March 18, 2010 by ashishprak |
 |
 |
What is the difference between Oracle's Rule Based and Cost Based optimizers? |
dtech-team |
1 |
177 |
March 18, 2010 by ashishprak |
 |
 |
Which data dictionary objects are used to retrieve the information about the fol |
dtech-team |
1 |
122 |
March 17, 2010 by dtech-team |
 |
 |
What are Database Roles ? What are the uses of Roles? |
dtech-team |
0 |
120 |
March 17, 2010 by dtech-team |
 |
 |
how to Collect the statistic for the table |
vivekmcm |
3 |
257 |
March 15, 2010 by ashishprak |
 |
 |
What is the function of Lock (LCKn) Process ? |
dtech-team |
0 |
126 |
March 15, 2010 by dtech-team |
 |
 |
What is function of RECO ? |
dtech-team |
0 |
114 |
March 15, 2010 by dtech-team |
 |
 |
What is the function of ARCH ? |
dtech-team |
0 |
92 |
March 15, 2010 by dtech-team |
 |
 |
What are functions of PMON ? |
dtech-team |
0 |
84 |
March 15, 2010 by dtech-team |
 |
 |
What are the functions of SMON ? |
dtech-team |
0 |
86 |
March 15, 2010 by dtech-team |
 |
 |
What is the function of checkpoint(CKPT)? |
dtech-team |
0 |
84 |
March 15, 2010 by dtech-team |