Useful solution for finding the date of first day of a given week, and year.
select decode(to_Char(to_date('01-JAN-'||&Cur_year),'DY'),'MON', to_date('01-JAN-'||&Cur_year),next_day(to_date('01-JAN-'||&Cur_year),'MON'))+(7*(&cur_week-1)) from dual
Value of Cur_year may be any year and Cur_week must be between 1-52.
Thank you Sandy for this solution.
Monday, November 12, 2007
Subscribe to:
Posts (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
-
Simple but very handy way of taking exports without knowing database password. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFIL...
-
Problem: I cannot see Oracle ODBC driver in datasource administrator in Windows 2003 64 bit. Cause: 64 bit 32 bit incompatibility issue for ...
-
What is consolidation? At first, it seems a process which enables making things with smaller number of resources. Below picture that depicts...