Latest Answer : %type will use for to define at column level.%rowtype is used to define for one or more than one columns ( like row or record or tuple ) means its user define type which hold one or more than one columns along with it. and generally it used with Cursor. ...
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 ...
Latest Answer : there are mainily 3 types of triggers1> dml trigger2>instead of trigger written on only view3>system triggerdml trigger written on table that gets fired on dml events like insert or delete or update operationthat trigger may ...
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.
How do i write a function that returnsmore than 1 records from a tablefor example in sql server there is a solution as create function f1() return table asselect * from emphow do i do the same in oracle. plz help
We have on delete cascade in Oracle but we don’t have on update cascade. If you compare Oracle with SQL Server in SQL Server we have the option called on update cascade but In Oracle we don’t have this option why? Please can you just clarify my doubt?
Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function.
Latest Answer : Hi,Let me answer your second questin first. Why ref cursor instead of %ROWTYPE.%ROWTYPE is used for fetches record/row of a single table.OR in case of columns of different tables then you have to create a RECORD and then used %ROWTYPE.But ...
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.
Latest Answer : A collection can be loosely defined as a group of ordered elements, all of the same type that allows programmatic access to its elements through an index. Commonly used collection types used in the programming world include arrays, maps, and lists. Probably ...
