1) WIll all the user get the DEFAULT profile, if their
current profile got deleted at any point of time?
2) What are the Situation we need to MOVE the TABLE between
T.spaces?
3) What is the use of MOVING the TABLE between SCHEMA'S?
4) What are the Table Clause, Segment Clause and the
Datafile Clause which will override each other?
5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
No Answer is Posted For this Question
Be the First to Post Answer
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
List the types of joins used in writing subqueries?
How to add a new column to an existing table in oracle?
State and explain the different types of data models?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
what are the database links ?
what is exact difference between drop and truncate table.
Why do we need oracle client?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Explain integrity constraint?
what are the disadvantages of hierarchial database over RDBMS?