Use of an integrity constraint is better to validate data. Explain
No Answer is Posted For this Question
Be the First to Post Answer
Explain the importance of .pll extension in oracle?
how to find find & delete duplicate rows from two different tables?
Describe an oracle table?
Explain a data segment?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Explain what are synonyms used for?
what is exact difference between drop and truncate table.
Can group functions be used in the order by clause in oracle?
How to concatenate two text values in oracle?
How to define a data source name (dsn) in odbc manager?
7. Repeat query (7) but also display all clients who have never ordered anything.
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