check for grants
please provide grant execute on function ..
gaurishere
Last Activity: Apr 17 '14, 10:08 AM
Joined: Sep 27 '13
Location:
-
Instead on decode u can used CASELeave a comment:
-
what exactly u want to store in which variable ...
u r assigning both variable to each other agn and agnLeave a comment:
-
Dear user
from here you can find when the last insert,update,d elete was happened on the tableCode:desc dba_tab_modifications
Leave a comment:
-
date format
in insert statement default is used (default '01011901')
even though
i have to usedCode:show parameter NLS_DATE_FORMAT NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ nls_date_format string DDMMYYYY
explain...Code:alter session set nls_date_format='DDMMYYYY';
-
...Code:SELECT max(sal) FROM emp WHERE salary < (SELECT max(sal) FROM emp); even u can check ur self 1 select max(sal) from Emp; MAX(SALARY) -------------------- 28.3 select sal from Employee order by sal desc 2 / SALARY -------------------- 28.3 12Leave a comment:
-
&Mon and &Year will allow u runtime parameterCode:select count(*) from time_data where to_char(fromdate,'Mon')='&Mon' and to_char(fromdate,'YYYY')='&Year'
like this
Enter value for mon: Mar
Enter value for year: 2013
Hope this query helps uLast edited by Rabbit; Oct 3 '13, 03:08 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.Leave a comment:
-
write query which will fetch the data from table by passing date as parameter on button click
eg select column from table_name from date_column between &fstart_date and &end_date
add order by if u want to display in order mannerLeave a comment:
-
no i got the results properly with above query with both queryLeave a comment:
No activity results to display
Leave a comment: