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
How many types of normalization are there?
What is execution plan in sql?
What are sql*plus environment variables?
Can variables be used in sql statements?
Show the cursor attributes of pl/sql.
What is procedure and function in sql?
What is a temporal table?
What is the difference between in and between in sql?
List the various privileges that a user can grant to another user?
what is bcp? When does it used? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is pl/sql language case sensitive?
What is the difference between delete, truncate and drop command?
What is the purpose of the partition table?
What is sql trigger example?
