Mahesh Kuhile

Greenhorn
+ Follow
since Mar 06, 2006
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Mahesh Kuhile

Hi,

U can go for oracle developer certification which contains 3 papers.

1. 1Z0-007 Introduction to Oracle 9i SQL
2. 1Z0-147 PL/SQL
3. 1Z0-141 Forms

You can get lot of stuff from yahoo group's file section.
Join groups oracle_developer_9i,oracle_study_materials.

Cheers,
Mahesh
14 years ago
Hi,

Yes Abhijit..u r right..!
I think in Pune Vertex is CMM 5 level company mainly having clients in Japan and they work mainly in Java.!

Cheers,
Mahesh
14 years ago
Hi,

U can accept the offer. But sometimes,i am not saying always there might be project which need something extra from u that means more working hours and all that stuff. u might not get time to study.

There are some eg,some of my batchmates done like this. 2 years in infy and then he went for MBA.

Basically u have to maintain the balance and project depents upon luck

HTP

-Mahesh
14 years ago
E-gain is good company to join.They are having clients like GENPACT,HSBC.
and work culture is also good. I think go ahead with this offer.
14 years ago
Hi,

Maintaining index is quite difficult thing. U need extra storage for that.
Again when there is DML operation on that table subsequently index need to be updated.

When user want to retrive data more than 5% it is not recommended to use index.

Second thing u r talking is about the order by. When order by is specified in the query sorting is done in memory which consumes lot of resoureses and makes the exection slow.

HTH..

--Mahesh
14 years ago
Hi,
U have to use following command,

alter table [table_name] drop constraint [constraint_name]

If u dont have the constraint_name then use following command retrive it.

select * from user_constraints where table_name = 'TABLE_NAME'

Hope this helps.

Thanks,
Mahesh
14 years ago