Latest Answer: Collection is an ordered group of elements all are of same time. Each element in the collection has unique subscript to identify its position in the collection.Pl/sql offers three collection types.1. Nested table2. Varray3. Index by table Use collection ...
If you write a function and procedure with performs same task and return a value, which will execute fast and why.
Latest Answer: By using SQL LOAER, TOAD we can insert EXCEL file data into respective Table & we can also create or upload ORACLE table data to .xls file from that.ThanksRajiv GuptaYogik Technologies Pvt. Ltd. ...
How can I write a function which returns previous business date of given input date1. skip holidays when you find previous day2. skip Sunday and saturday's when you find previous dayUS holidays are
Latest Answer: if you need to get the previous business date, just change the in_dt variable in declaration to input_dt date := '&Dt';in_dt date := input_dt - 1; ...
Latest Answer: 1) First identify the current excecution plan by using showplan.In most cases, creating and then forcing usage of the indexes result in drastic improvement.1) Ensure that indexes(single or composite) exist for columns referred to in the where clause.2) ...
Latest Answer: You cannot move existing table into a cluster. You can create new tables though, including tables with the same contents as existing tables. In the second. form, query returns a set of rows which are inserted in the newly created table. The query ...
Latest Answer: there are hundreds of build-ins avialable few ones areDBMS_OUTPUT.PUT_LINE, DBMS_SQL, DBMS_DDL, DBMS_PIPE, DBMS_JOB ...
Latest Answer: Declare the collection variable (varrys or PL/SQL tables)Â as out parameter for the procedure and fetch the result set into collection variable. ...
How can I use the bind variable in a report to create an output file. For example I give the starting date and end date. I would like to get the report output in a file which has the start date and end date in it's name.
What is the difference between IS/AS while creating a procedure ?i.e Create or Replace procedure is/as .....
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
