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 ?
2023why 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 5199how 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....
1570when 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 3308How 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 4039I 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 3620A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
7 7565cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
2 3947how 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?
1506Post New Oracle General Questions
types of indexes and the rationale behind choosing a particular index for a situation.
why dont we assign not null constraint as table level constraint.
What is Library Cache in Oracle?
What is tns entry?
How many memory layers are in the oracle shared pool?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to run create database statement again?
How do I reset a sequence in oracle?
How to sort output in descending order in oracle?
Are truncate and delete commands same? If so why?
What is a named program unit?
Explain the use of grant option in exp command.
What are the different oracle database objects?
Is truncate autocommit in oracle?
What is the relationship among database, tablespace and data file?