what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?1600
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?1 4474
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....1138
what is candidate key & super key1 2375
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?2 2534
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.2 3154
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 it2 2789
How to display the hierarchy of employee and managers without using connect by prior.1 2599
find the second highest salary of the emp table6 4939
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?7 5636
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..2 3059
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?1104
How to create id with auto_increment on oracle?
How to define an anonymous block?
What is oracle data type?
What is a table in oracle?
How can you merge two tables in oracle?
Explain the use of rows option in imp command.
Is oracle the best database?
What is data block in Oracle?
What is an oracle user account?
How to apply filtering criteria at group level in oracle?
What is materialized view in Oracle?
What are the most common interview questions on ETL Testing for experience?
What is Java Pool in Oracle?
What is a sub query? Describe its types?
Is postgres faster than oracle?