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 ?
1600why 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 4474how 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....
1138when 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 2534How 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 3154I 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
2 2789A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
7 5636cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
2 3059how 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?
1104Post New Oracle General Questions
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?
