How do I recompile a procedure in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to calculate date and time differences in oracle?
What are the different types of partitions in oracle?
what is the difference between data migration and production migration.
How translate command is different from replace?
What is blob data type in oracle?
What is meant by joins?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
How to write an inner join with the where clause in oracle?
What is an Index ? How it is implemented in Oracle Database ?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
How to select an oracle system id (sid)?