Bulk Bind is the facilty through which we can INSERT, UPDATE, DELETE or SELECT from records from a table in bulk rather than multiple individual statments..Suppose you have 10 inserts to be made so yo...
Below is the correct query according to me..
select to_date('19-aug-2010', 'dd-mon-yyyy') - to_date('10-aug-2010', 'dd-mon-yyyy') as numberofdays from dual;
Let me know if it does not work..
Use below query to find number of days between two given dates -SQL> select to_date('30-aug-2010','dd-mon-rrrr') - to_date('20-aug-2010','dd-mon-rrrr') num_days from dual;NUM_DAYS
----------
10
SQL>
Pragma RESTRICT_REFERENCES is a compiler directive.It makes sure that the function maintains the purity rules and code in fuction creation satisfy the purity rules.There are 4 values for it.WNDS,RNDS,WNPS,RNPS.ThanksJai Sainath
Kullai Naidu
Mar 5th, 2007
By using pragma_restrict_references we can give the different status to functions,Like WNDB(WRITE NO DATA BASE),RNDB(read no data base),Write no package state,read no packge state.W
Here is the answer in 1 lineIN-- value is used in a program. It cannot be a variable .COuld be literal,expression,value .OUT-- value is returned back from the progr...
hi friends,To make it simple, keep in mind,IN : It is a CONSTANT in the sub-program and u can not modify its value in sub- program. if its value is modified in the s...