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 ?
2519why 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 6179how 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....
2118when 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 4383How 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 5091I 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 4964A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
7 10078cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
2 5063how 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?
2054Post New Oracle General Questions
What is Library Cache in Oracle?
What is the maximum number of triggers that can be applied to a single table?
What is the string concatenation operator in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to filter out duplications in the returning rows using oracle?
What is oracle datasource?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to convert dates to characters in oracle?
How to create a stored program unit?
How to count duplicated values in a column in oracle?
how can we store any pdf file in oracle
What are privileges and grants?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What are the execution control statements in oracle?
Why is oracle database so popular?