Interested to Buy Any Domain ? << Click Here >> for more details...
I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.
- 15 Answers
- 50363 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pracheth
select * from temployees where to_char(hiredate,
'month') in
(to_char(trunc(sysdate,'month')-30,'month'),to_char(trunc(sysdate,'month')-60,'month'))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Difference between global and parameter variables?
Differentiate between sga and pga.
Can we create table in function?
In what condition is it good to disable a trigger?
Enlist the data types that can be used in pl/sql?
What is null in pl/sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is pivot in sql?
What is dialect in sql?
What are all the common sql functions?
Are dml statements autocommit?
what does the t-sql command ident_current does? : Transact sql
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 memory optimized table?
What is the maximum number of columns in sql table?
