Latest Answer : Yes we can relate two tables from 2 diff usersE.g. if user A has table Ta and User B has Table Tb and Table Tb is child table and needs foreign key on A.Ta then we need to grant "references" object privillege to User B on table ...
What are the different types of collections supported in Oracle?PL/SQL datatypes TABLE and VARRAY, allow us to declare the collections nested tables, associative arrays, and variable-size arrays.
What is mutating trigger? How do you resolve it?If a trigger body is trying to update dependent tables, will it get a mutating error?
Latest Answer : A nested loop is a loop within a lop, an inner loop within the body of an outer one. How this workds is that the first pass of the outer loop triggers the innter which executes to completion. Then the second pass of the outer loop triggers the loop again. ...
Latest Answer : In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping construct strategy for storing and retrieving. In terms of performance comparison while retrieving data from both strictures hash join is best in terms ...
How to write a query or procedure or function to retrieve all the tables from database where the table dont have any data (no rows).
Database has 100 tables and some of the tables dont have any data. I want to pullout those table names from database in Oracle.
For example: I have 100's of tables and I need to take the data from database and export as a xml file.
For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started,
What is the difference between Nested Table and Normal Table?
Latest Answer : Normal Table : It contain rows and columns.Each Row-Column represente only one value i.e intersection of Row-Columncreate table t1(col1 number(10), col2 varchar2(9));------>Creates normal tableNested Table : It contains some Row-Column as another ...
How to create temporary table? Give some example
Latest Answer : create table temp as select*from base table where 1=1; ...
