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 ?
2465why 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 6109how 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....
2058when 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 4284How 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 4999I 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 4873A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
7 9837cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
2 4963how 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?
2005Post New Oracle General Questions
How to invoke the data pump import utility?
What is a dynamic performance view in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
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?
What is the difference between post-database commit and post-form commit?
What is integrity and what is constraint??Explain with example
how to join query for one source type is oracle another source type is sql server ?
How do you find current date and time in oracle?
Can group functions be used in the order by clause in oracle?
Does oracle partitioning improve performance?
What language does oracle use?
Is postgres faster than oracle?
What is oracle data type?
What is open database communication (odbc) in oracle?
How to rename an index in oracle?