 Related Questions Latest Answer : Cursor is a private Sql area which is used to execute sql statements and store Processing information, Where as Refcursor is a data structure which points to an object which inturn points to memmory LocationThe advantage Refcursor over Normal Cursor is1.We ... Latest Answer : SQL is a structured query language.Used to perform operations such as retrieval,updations,insertions etc. on database.PL/SQL is a Programming language which is an extension for SQL with control structures added to them.Number of SQL statements can be ... How to query to know, that dbms_rowid package contains ROWID_OBJECT, rowid_block_number ,etc procedures or functions in it. Latest Answer : A Unique Key can have null values but a Primary Key can't have null values ... Read Answers (21) | Asked by : Babar Shabbir 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 : no difference ... Read Answers (9) | Asked by : Suyog Latest Answer : GRANT and REVOKE are DCL commands ... ... How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ? 1.what is difference between pl/sql table and records?2. what is the advantages of pl/sql table?3. what is ref cursor? what is the advantages of ref cursor Hi 1.What is difference between procedure and function?1. procedure may or may not return values whereas function must return value2. we can call the function in the sql statements whereas we can't call the procedureExcept these two, is there any difference between these two.2. What is pl/sql table and what is use of it. In which case, we can use it3. What is ref cursor, what is the use of it.4.how the function will return multiple values. Pls give me with examples
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
