|
| 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 Hi,i want to know that,Will the functionality of these two statements:EXEC SQL SET TRANSACTION READ ONLY END-EXECEXEC SQL SET TRANSACTION READ WRITE END-EXECare same as “EXEC SQL SET TRANSACTION REPEATABLE READ END-EXEC”Give me the replacement for the above 2 sql statements.thanks in advance,rashmi Read Answers (1) | Asked by : rashmi 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 ... Read Answers (1) | Asked by : Shankar 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 ... Read Answers (5) | Asked by : GIRISH H.R. 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? Read Answers (1) | Asked by : inam What is pragma autonomous transaction? Plz can u let me know it in a simple understandable way.Thanks in advance.Byee Read Answers (6) | Asked by : raj 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. Read Answers (3) | Asked by : Robert
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
