vegad

Hi,anybody help me plzI would like to design a system that models the way the client browser works. THe system must allow user to enter a new URL into the system an deither go back to a URL loaded previous to the current URL or go forward to a URL loaded after the current URL.The storage mechanism must include two stacks (one backward and one forward) both of them must exhibit the behaviours:LIFOPop item from stackPush item from stackEmpty stack.So the backward stack stores items of previously visited URL and the forward stacks stores item moved from the backward stack to the forward stack.The system should allow to enter a new URL, recover URL from the backward stack, and recover URL from the forward stack.help me plz.....

HAVE TRY THIS CODE AFTER U GIVE ME SUGESTION....select OP_DATE,to_char(Op_date, 'DAY')OPER_ONfrom operationwhere op_date between '1-jan-2004' and '31-dec-2005'/AND I GOT THIS TYPE OF RESULT......SHOWN BELOWSQL> EDWrote file afiedt.buf1 select OP_DATE,to_char(Op_date, 'DAY')OPER_ON2 from operation3* where op_date between '1-jan-2004' and '31-dec-2005'SQL> /Hit <RETURN> to continue ...OP_DATE OPER_ON--------- ---------11-JAN-04 SUNDAY02-JUN-04 WEDNESDAY14-AUG-04 SATURDAY26-NOV-04 FRIDAY19-MAR-05 SATURDAY27-APR-05 WEDNESDAY31-JUL-05 SUNDAY7 rows selected.SQL> BUT I ONLY WANT SATURDAY AND SUBDAY FROM DATA,...CAN U GIVE ME ANY SUGESTION.....I WANT ONLY 4 ROWS....WITH SATURDAY AND SUNDAY.......I M WAITING FOR U RREPLY..THNKS FOR GIVE ME ANS..OF MY QUS.....WAITHING 4 UR REPLY......

hii have one more qus for u..Qus ; 2 Display the surname and telephone number of all patient who were admitted in the last 6 months who did not receive an operation.for this qus. i have two table one is ' patient_visit' and other one is 'operation'patient_visit <patient#,DOAdmission, DODischarge,Ward_Id>operation<operation#, Op_date, Op_type, Patient#, DOAdmission, Time_slot, theatre#>i want to find out that a patient who were admitted but not receive an operation from last 6 months.give me your idea...about that qus....and code reference also.....thanks waiting for u reply.....ok....bye

I HAVE TRY THIS CODE AFTER U GIVE ME SUGESTION....select OP_DATE,to_char(Op_date, 'DAY')OPER_ONfrom operationwhere op_date between '1-jan-2004' and '31-dec-2005'/ AND I GOT THIS TYPE OF RESULT......SHOWN BELOWSQL> EDWrote file afiedt.buf 1 select OP_DATE,to_char(Op_date, 'DAY')OPER_ON 2 from operation 3* where op_date between '1-jan-2004' and '31-dec-2005'SQL> /Hit <RETURN> to continue ...OP_DATE OPER_ON--------- ---------11-JAN-04 SUNDAY02-JUN-04 WEDNESDAY14-AUG-04 SATURDAY26-NOV-04 FRIDAY19-MAR-05 SATURDAY27-APR-05 WEDNESDAY31-JUL-05 SUNDAY7 rows selected.SQL> BUT I ONLY WANT SATURDAY AND SUBDAY FROM DATA,...CAN U GIVE ME ANY SUGESTION.....I WANT ONLY 4 ROWS....WITH SATURDAY AND SUNDAY.......I M WAITING FOR U RREPLY..THNKS FOR GIVE ME ANS..OF MY QUS.....WAITHING 4 UR REPLY......

i have try this and i got the period of 2004 and 2005 . at that time an operation was carried out ..in this data i put some date from calander and some of them are sunday and saturday.......but i dont know how to retrive a day like i want sunday......my real qus is that.....For the period of 2004-2005 find out the number of operation carried out on a saturday and sunday....i m using sql*plus...SQL> edWrote file afiedt.buf 1 select op_Date 2 from operation 3* where op_date between '1-jan-2004' and '31-dec-2005'SQL> /Hit <RETURN> to continue ...OP_DATE---------11-JAN-04 02-JUN-0414-AUG-0426-NOV-0419-MAR-0527-APR-0531-JUL-057 rows selected.SQL> this are the operation carried out in year 2004 2005 but i want how many operation carried out on sundya and saturday.....i want day insted of date....which i found by my querry...thaks.....plz reply me as soon as possible...thanks again for the ans of my first qus but i m sorry i not setisfied with that.....i m sorry........

helloevery onei have one problem with retrive data from table.....my qus. is how to retrive only sunday form a particuler time period of year 2004 and 2005.i have a qus like that....---- For the period 2004-2005 find the number of operation carried out on a sunday.its very urgent i want ans before friday if it is posible.if any body know about that plz send me e- mail my e-mail id is vegad_dk@yahoo.co.inthank u i m waiting for ur your valueable reply......