How to configure Oracle 10g on Sun Solaris 10 platform?
How to clasify the constraints in a table? Which columns are associated to primary, composite primary, unique, and not null constraints while the inserting rows into a table?
What is the use of mentioning of constraint_name along with NOT NULL Constraint _type while creating a table?
How do we can see savepoint names list?
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
Latest Answer: AND operator takes precedence over the OR operator ...
SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM
Latest Answer: Here compulsory to give the alias name for rownum because the column name is not exist in the table so it's show error for invalid columns specification.The query should be below;select * from (select rownum as num, last_name, salary, id from employeewhere ...
What is rebuild index, why do we need to rebuild the index?
Latest Answer: If you want a table moved from its own tablespace to other, then you have to rebuild index.Command:Alter Index index_name rebuild online; ...
What is the purpose of Mviews? Outline the difference between refresh types? How to refresh the MView?
How to find the timezone of the database?
How many exception in Oracle?
Latest Answer: In Oracle there are two types of exceptions.USER DEFINED EXCEPTIONS.DEFINED EXCEPTIONS..(NO_DATA_FOUND,VARIRABLE LENGHT TOO LONG .. etc.) ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
