|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 ... Read Answers (1) | Asked by : Shankar 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? Read Answers (6) | Asked by : be17be 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. Read Answers (3) | Asked by : Robert 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, How to create temporary table? Give some example Latest Answer : create table temp as select*from base table where 1=1; ... How do you create nested tables?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0