Explain what are the advantages of views?
No Answer is Posted For this Question
Be the First to Post Answer
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is the difference between RBBMS & DBMS?
How do I manually create a database in oracle?
What are the composite date types in oracle?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
What is an oracle tablespace?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What is Trigger in Oracle?
What is the meaning of recursive hints in oracle?
How to define a data field as not null?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How to define a record variable to store a table row?