|
| 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 What is cursor? Explain the types of cursor and write one implicit cursor program to check how many records deleted from table? Read Answers (5) | Asked by : indranil 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. ... How can we find the status (enabled/disable) of the trigger and the user who changed the status in SQL-Server.Many thanks. Read Answers (2) | Asked by : Shahid Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is it 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 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
