Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sujit pingale
select to_char(sysdate, 'day') from dual;
This will print output: tuesday i.e
select last_day(sysdate) from dual;
This will print output: 31-Aug-14
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which type of cursor is used to execute the dml statement?
What is lexical units in pl sql?
What is a database trigger?
What is difference between table and view?
how can we know the number of days between two given dates using mysql? : Sql dba
What are the main features of cursor?
what is commit? : Sql dba
How to disable a trigger name update_salary?
Why do we need databases?
List and explain the different types of join clauses supported in ansi-standard sql?
Which data type is a composite type?
How do I find sql profiler?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is sql used for?
What is a trigger in sql?
