OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Oracle sql help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle sql help [message #71013]

Tue, 27 August 2002 03:42

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

i want calculate how many sundays in a month.i was preparing a software which name is attendance ,where i require this to caluclate the how many sundays(Rest day) in a month, which is not calculate in the calculation of his/her salary.example if the month has 30 days and work days is 26. it means that the four sunday(restday) in a month.

please response me as soon as possible.
thanks
shah1419@yahoo.com

Report message to a moderator

Re: Oracle sql help [message #71015 is a reply to message #71013]

Tue, 27 August 2002 04:20

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

local@ >ED
Wrote file afiedt.buf

  1  SELECT
  2  ((NEXT_DAY(LAST_DAY(TRUNC(SYSDATE))-7,'SUNDAY')
  3  -NEXT_DAY(TRUNC(SYSDATE,'MONTH')-1,'SUNDAY')) / 7)+1
  4  AS SUNDAYS
  5* FROM DUAL
local@ >/

   SUNDAYS
----------
         4

Report message to a moderator

Re: Oracle sql help [message #71617 is a reply to message #71013]

Tue, 03 December 2002 16:26

bIgmAC
Messages: 1
Registered: December 2002

Junior Member

How do i "determine the name of an expensive book"

I had:

select book_title, max(book_price)
from book_om;

I thought about using the "Distinct", but it did not work.

Report message to a moderator

Re: Oracle sql help [message #72069 is a reply to message #71013]

Sat, 01 March 2003 19:52

santosh
Messages: 85
Registered: October 2000

Member

I like to save the database or table created in oracle in the floppy to install on the system so that i can install software any where.
guide me to do that

Report message to a moderator

Previous Topic:	archetecture
Next Topic:	Re: oracle 8i PE installations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 22:10:52 CDT 2024