|
Subject |
Started by |
Replies |
Views |
Last post  |
 |
 |
How Useful is the Parent Site and This Forum |
dtech-team |
4 |
660 |
January 09, 2010
by jignesh |
 |
 |
am working on one query which is taking more time to execute it. |
lakshmanraok |
3 |
71 |
August 31, 2010
by prabhu |
|
|
|
Is COMMIT faster or ROLLBACK and why |
sudha |
1 |
23 |
August 30, 2010
by dtech-team |
|
|
|
Can any body tell me the real life business scenerio |
vivekmcm |
3 |
26 |
August 18, 2010
by dtech-team |
|
|
|
What are Constraining tables? |
vivekmcm |
0 |
16 |
August 17, 2010
by vivekmcm |
|
|
|
What is implict index and explict index |
vivekmcm |
1 |
26 |
August 16, 2010
by dtech-team |
|
|
|
Interview question: on Table and View |
lakshmanraok |
2 |
63 |
July 26, 2010
by sagilisowmya |
|
|
|
use of WITH clause in oracle |
banarasraj |
3 |
90 |
July 12, 2010
by lakshmanraok |
|
|
|
How to fetch rows using Bulk collect and insert thousands of rows into the table |
lakshmanraok |
0 |
50 |
July 12, 2010
by lakshmanraok |
|
|
|
Why my Indexed column not taking while executing the query |
lakshmanraok |
0 |
35 |
July 12, 2010
by lakshmanraok |
|
|
|
Can anybody explain the following terms with example i.e. real life scenerio |
vivekmcm |
2 |
257 |
July 09, 2010
by vivekmcm |
|
|
|
variable name in LIKE operator |
banarasraj |
1 |
39 |
July 09, 2010
by sibanjan |
|
|
|
with out hard coding how can i get col'm as rows and rows as col'm..like i want |
banarasraj |
2 |
62 |
July 09, 2010
by sibanjan |
|
|
|
In DECODE function null = null why? |
banarasraj |
3 |
65 |
July 01, 2010
by banarasraj |
|
|
|
I want to write a query to display the rows like |
lakshmanraok |
2 |
58 |
June 28, 2010
by lakshmanraok |
 |
|
What is the query to return department wise second highest salary ? |
sibanjan |
8 |
124 |
June 27, 2010
by Pawan |
|
|
|
Interview Exam questions on the behavior of "NULL" in Oracle |
kushi |
3 |
792 |
June 25, 2010
by avinash |
|
|
|
what is count(*) over () do |
vivekmcm |
1 |
66 |
June 25, 2010
by avinash |
|
|
 |
10% Discount to All Forum Members on our 250 Oracle Interview Q&A Intw Prep Kit |
dtech-team |
0 |
44 |
June 24, 2010
by dtech-team |
|
|
|
to change date in words |
amitkpandey |
3 |
74 |
June 19, 2010
by vanivenukoti |
|
|
|
I have deleted one row and I commited the transaction. is it possible.. |
lak |
2 |
74 |
June 18, 2010
by amitkpandey |
|
|
|
Query tuning... |
lak |
0 |
49 |
June 11, 2010
by lak |
|
|
|
I am using indexed column in my select statement...but |
lak |
0 |
36 |
June 11, 2010
by lak |
|
|
|
Explain Oracle merge join and hash join? |
vivekmcm |
2 |
280 |
May 21, 2010
by dtech-team |
|
|
|
How to pass hint through query & types of hints in oracle |
lakshman |
0 |
65 |
April 26, 2010
by lakshman |
|
|
|
Using Extend to VARRAY |
dba_lollo |
5 |
211 |
April 25, 2010
by manishash |
|
|
|
What is function and procedure and package? Advantages? |
dtech-team |
3 |
323 |
April 25, 2010
by sibanjan |
|
|
|
what is oracle VPD? |
sibanjan |
0 |
63 |
April 20, 2010
by sibanjan |
|
|
|
Creating table in PL/SQL block |
smyneni |
2 |
103 |
April 16, 2010
by smyneni |
|
|
|
What is a Deadlock? Explain. |
dtech-team |
2 |
125 |
April 15, 2010
by sibanjan |
|
|
|
How to schedule an Oracle job which runs every half an hour only betw 8 AM-8 PM |
Ciciliya |
10 |
446 |
April 14, 2010
by ashishprak |
|
|
|
Difference between count(*) and count(1) |
dearcyril |
3 |
580 |
April 11, 2010
by ashishprak |
|
|
|
What is a check constraint? How to create Check constraints? |
jignesh |
2 |
404 |
April 10, 2010
by ashishprak |
|
|
|
Interview Question- GLOBAL TEMPORARY TABLE v/s Normal table |
ashishprak |
2 |
271 |
April 07, 2010
by manishash |
|
|
|
Why primary key is not enabled without an index on it. |
vivekmcm |
1 |
117 |
April 07, 2010
by kushi |
|
|
|
how we can see all the object assoicated with a table |
vivekmcm |
1 |
109 |
April 07, 2010
by kushi |
|
|
|
how the query work any body can tell |
vivekmcm |
2 |
93 |
April 03, 2010
by sibanjan |
|
|
|
Retrieving data from 2 or more tables at same time |
pindiganti |
2 |
82 |
April 03, 2010
by sibanjan |
|
|
|
Does anybody know the difference between a Varchar and Varchar2? |
sanjeev |
4 |
148 |
March 30, 2010
by sibanjan |
|
|
|
SQL QUERY TO ROLLOVER PREVIOUS YEAR VALUES TO CURRENT YEAR |
Pranitha |
4 |
125 |
March 19, 2010
by kushi |
|
|
|
Can any one tell about Oracle pseudo column ? |
mohan_psv |
1 |
84 |
March 11, 2010
by dba_lollo |
|
|
|
How to disable & in SQL Iam writing the following query but Iam unable to get |
vivekmcm |
2 |
735 |
March 10, 2010
by mohan_psv |
|
|
|
What are hints? Usage of hints? Example of hints and where are they used? |
dtech-team |
1 |
344 |
March 10, 2010
by mohan_psv |
|
|
|
Can we Truncate the table using DB link |
vivekmcm |
4 |
135 |
February 26, 2010
by ashishprak |
|
|
|
How to see the my table is locked |
vivekmcm |
2 |
131 |
February 03, 2010
by dtech-team |
|
|
|
Can we update table through view in Oracle? |
jignesh |
2 |
256 |
February 03, 2010
by kamal30385 |
|
|
|
WHat is the Validity of Oracle certification |
vivekmcm |
1 |
51 |
January 29, 2010
by dtech-team |
|
|
|
Encrypt database password |
Jane |
1 |
61 |
January 26, 2010
by dtech-team |
|
|
|
Working in dbms_lob package |
dearcyril |
6 |
77 |
January 11, 2010
by dtech-team |
|
|
|
2) what are the benefits of the using bind variables? |
dtech-team |
2 |
401 |
January 11, 2010
by Jane |
Topic you have posted in
Very Hot Topic (More than 15 replies)
Locked Topic
Sticky Topic
Poll