 Related Questions Plz clarryfy this.Scinario is whether we can use out mode in functions?.I thought it's not possible. Plz clarryfy this.Scinario is whether we can use out mode in functions?.I thought it's not possible. But in interview they are asking this.if i am telling no,they are not accepting me.Plz clarify this anyone. Read Answers (9) | Asked by : George Suresh What is the Scalar Data type in PL/SQL?what is the forward decleration in packages?what is the usage What is the Scalar Data type in PL/SQL?what is the forward decleration in packages?what is the usage of IN,OUT,INOUT parameters in Procedures or functions? Read Answers (5) | Asked by : chiranjeevi reddy How to query to know, that dbms_rowid package contains ROWID_OBJECT, rowid_block_number ,etc procedures or functions in it. Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? 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 How can i get the procedure's, function's name from a package if it is wrapped(both spec & body). Read Answers (2) | Asked by : biswajit Latest Answer : A table function is a function that returns an entire set of rows, and can be queried directly from the within a SQL statement, as if it were true database table. Whereas pipeline function is similar, but returns the data as it is constructed rather than ... Read Answers (1) | Asked by : navneet How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ? Hi,We have to select some rows from a table using many conditions in the where clause. Then we have to write those selected rows to one flat file. I know that we can use UTL_FILE package to do this. Is there any better approach to do this?? Read Answers (5) | Asked by : Ritesh
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
