SQL & PL/SQL :: Show Week Days Without Friday And Saturday
Oct 25, 2011how can create function or sql statement to show week of days without Friday and Saturday
View 13 Replies
ADVERTISEMENT
SQL & PL/SQL :: How Many Days Thursday And Friday Between Two Dates
Nov 13, 2011I want function return me how many days Thursday and Friday between two dates.
View 1 Replies View RelatedSQL & PL/SQL :: Schedule Procedure On Days Of Week At Specific Time?
Apr 12, 2010I need to schedule a procedure on SUN, MON,TUE, WED and THU at 6:30 AM. make sure the folloiwng code is o.k.
begin
dbms_scheduler.create_job
(job_name => 'Load-Data_Calc',
job_type => 'STORED_PROCEDURE',
[code]...
Field Constraint For Days Of Week Using Single Letter Representation
Jul 6, 2013I know I can add a check constraint for m,t,w,r,f,s,u How can I add a constraint that will allow any combination of the above. For example it would allow m or mf, or mwf Someone said it could be done with trim but I can not figure it out.
View 1 Replies View RelatedSQL & PL/SQL :: Show Number Of Days Between Two Dates?
Apr 18, 2013i want to create function to show number of days between to days such as number of Friday days between to dates
View 13 Replies View RelatedPL/SQL :: Right SQL To Show Employees Detail Attendance According To Number Of Days
Jun 12, 2012There is a attendance table having structure(empid number,signtime datetime)It has data of attendance of employees:
What is the right sql to show employees detail attendance according to the no of days attendance . i.e.(According to the maximum no of attendance first and so on)
suppose: 3 employees abc,bbc,cca abc has 20 days of attendance ,bbc has 21 days,cca has 19 days..The report like this:
bbc 1/5/12 10:30
abc .....
then
cca
according to the no of attendannce
Server Administration :: Overlapping Days Between 3 Date Ranges To Determine Active / Inactive Days
Sep 2, 2011I have installed Oracle Database 11g.2 by database configuration assistant on windows XP as and adminstrator on my laptop(no connection to network),but when I want to create database I face this warning: error securing database control ,Datatbase control has been brought up in non-secure mode . to secure the database conntrol execute following command....(error is attached).
View 7 Replies View RelatedFunction To Return Last Friday Of Month
Sep 26, 2010I was just wondering that do we have any function available in oracle which returns the last Friday of the month.
In our company we close our monthly books on last Friday of the month and there are few activities that we have to do on the following Monday as a part of month-end activity. Now the following Monday can fall on the same month or at times it falls on the following month.
I have to schedule a report to be sent to a user on the following Monday after the month-end. I need to schedule it using the cron job.
We are using Oracle 9i on Linux platform.
SQL & PL/SQL :: How To Convert Days Into Weeks And Days (if Any) Oracle 9i
Apr 5, 2011want to write Procedure to return weeks and days from given set of days.
let suppose we have 72 days to return weeks and days then return should be 7 weeks and 2 days.Can i use date function Or ?
Performance Tuning :: Materialized View Which Should Refresh Every Tuesday And Friday At 5am
Mar 20, 2012I need to create a Materialized View, which should refresh every Tuesday and Friday at 5am.
CREATE MATERIALIZED VIEW DUAL_MV
TABLESPACE USERS_SMALL
REFRESH NEXT NEXT_DAY(TRUNC(SYSDATE), 'TUESDAY') + 05/24
AS SELECT * FROM DUAL;
I can do it for single day like above, but how to refresh on multiple days, using create materialized view syntax .
SQL & PL/SQL :: Finding List Of Second And Forth Saturday In Particular Year?
Jun 30, 2011i have one query. i want to Find the list of second and forth Saturday in a particular year.
View 6 Replies View RelatedPL/SQL :: Output Order Like Sunday To Saturday
Sep 20, 2013Select to_char(hiredate,'Day'),count(empno)
from empgroup by to_char(hiredate,'Day')order by to_char(hiredate,'Day')
SQL & PL/SQL :: How To Calculate Between 2 Dates Excluding Saturday And Sunday
May 3, 2012select to_date('25-04-2012', 'DD-MM-YYYY') + rownum -1 dt
from dual
connect by level <= to_date('05-05-2012', 'DD-MM-YYYY') - to_date('25-04-2012', 'DD-MM-YYYY') + 1;
The above query returning the following output,
DT
04/25/2012
04/26/2012
04/27/2012
04/28/2012
04/29/2012
04/30/2012
05/01/2012
05/02/2012
05/03/2012
05/04/2012
05/05/2012
here I need to exclude the Dates which comes on 'saturday' and 'sunday' and also the common holiday..Here it is '01-May-2012' and I need the output like the following,
DT
04/25/2012
04/26/2012
04/27/2012
04/30/2012
05/02/2012
05/03/2012
05/04/2012
I need the common query to calculate between any two dates.
SQL & PL/SQL :: Write A Function To Eliminate SUNDAY AND SATURDAY?
May 9, 2012i need to write a function to eliminate SUNDAY AND SATURDAY;
My criteria is
if My date as (5/19/2012 ) and i want to add 10 days to it themn my function should return 06/01/2012
if My date as (5/13/2012 ) and i want to add 12 days to it themn my function should return 05/29/2012
Application Express :: To Change The Default Behavior Of Hide / Show Region To Show
Jun 26, 2012I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies View RelatedSQL & PL/SQL :: Find Missing Date For A Year Excluding Saturday And Sunday
Feb 3, 2011I given the table name,column name,datatype and sample record in the table. I have given the sample record for 01-jan-2008 to 8-Jan-2008, but in the real thing it will be for 30 years.
My Requirement:
For each class_no (202,203..), I need the missing date excluding weekends (sat, sun), I have provided the sample output below.
Table Name : ABC
Column Name : Class_no Data Type : Number
Column Name : Class_DateData Type : Date
Sample Record in the Table :
Class_noClass_Date
202 1-Jan-08
202 2-Jan-08
202 7-Jan-08
202 8-Jan-08
203 1-Jan-08
203 2-Jan-08
203 3-Jan-08
203 7-Jan-08
203 8-Jan-08
OUTPUT:
Class_noClass_Date
202 3-Jan-08
202 4-Jan-08
203 4-Jan-08
SQL & PL/SQL :: Count Of Updates By Week
Feb 19, 2013I have a table of records with a date_modified column. I would like to simply report the count of updates made each week. For example, given:
Record Date_Modified
155291141/23/2013
157277201/24/2013
152619321/25/2013
142263211/28/2013
140043421/28/2013
150050431/28/2013
148315761/29/2013
154364281/31/2013
148066382/1/2013
[Code]...
I would like to return:
Week Updates
43
57
69
77
84
Although in place of the week number, providing either the value for the last day of the week or the first day of the week would be just as good.
how to go about this task.
SQL & PL/SQL :: Week On Particular Day According To Arabic Calendar
May 26, 2013As my requirement is that to find week for particular date according to Arabic calender.As per Arabic calender first day for year starts from saturday.
so when i execute query :
select to_char(to_date('05/26/2013','MM/DD/RRRR'),'WW')
from dual;
Then it gives 21,but as per arabic calender it should show 22nd week.
getting result according to Arabic calender as it should return 22,because weak starts from saturday according to Arabic calender.
PL/SQL :: How To Get Monday Of Every IW Week In A Year
Jun 29, 2012I had to get a query to give me all the Mondays of a IW week in a year. I think as per the IW weeks there are around 52.1 weeks in a year. So basically, I want the starting Monday of every week. I would then store those values in a variable and use them in APEX as column headers. Online I saw some samples not related with this, but where looping was done using the all_objects. Not sure if that is the right approach.
The problem is since this is not stored in any table, how can I loop like 52/53 times such that the output shows all the Mondays (date format) for a given year. Basically, the output would be 52/53 rows with a date(Monday of the week).
PL/SQL :: Change Monday Like First Day Of Week
Oct 18, 2012I need to change Monday like first day of week and not Sunday.
select to_char(to_date('01-01-2012'),'w') from dual
Result: 1
select to_char(to_date('02-01-2012'),'w') from dual
Result:1
and the idea is that 02-01-2012 must be the second week
To Restore Database To Last Week
Dec 31, 2012I am running 10g on Linux, and last week someone messed up a database and it needs to be restored to 27 December. I am not a DBA, out regular DBA is on vacation till mid January,
I know we have archivelog on (I can see .arc files for the database), and I also have a backup of the actual data files and control files from when the database was first created. So in other words, I have all archive files and the initial data files. What i do not know is how to set the restore till December 27.
Date Search By Last Week / Month?
Nov 2, 2011I have a create a report for our dept with certain criteria. So far what I need is a report that shows last weeks numbers or sign ups. I can't get the date search or between to work.
What I need is one for month end and one for last 7 days.
here's what I have so far.
select ap.name
to_char(ap.opendate,'MM-DD-YY') "Open Date"
from [databasname]
where ap.opendate between databasename-7 and databasename-1
I really don't want to change the date myself I want the system to know when the 7 days or month is.
SQL & PL/SQL :: Find Start And End Date Of Week?
Feb 5, 2011 I am creating report for this i want to make one query..
Query like this
My input is YEAR, MONTH AND WEEK and i want to find out start date and end date for this week...
Scenario like this
-----------------
I/P - Year = 2011, WEEK = 2 , Month - FEB
i will get o/p like this '06-feb-2010' and '12-feb-2010'...
SQL & PL/SQL :: Get Date From Year / Week And Weekday
Apr 5, 2011How to get a date using Year (say 2009), Week (35) and Weekday (5). I have read only permission to database, so I can not create a function.
View 8 Replies View RelatedSQL & PL/SQL :: Display 1st Day Of Week Within Date Range
Jul 14, 2010How to display date every monday within date range
DEsc start date end date
XXXX 1/2/2010 31/10/2010
output
date every monday
SQL & PL/SQL :: Get First Week Starting With First SUNDAY Of Year
Nov 9, 2012I want to get the week of the year.
Conditions are:
1. Year's first week starts with first Sunday of the year. (6th Jan 2013 will be the starting week (week 1) in Year 2013)
2. 2nd Jan 2013 will be the last week of the previous year i.e. 2012 (either 52th or 53rd week)
At many place I found the below solution:
select to_char(to_date('01-JAN-2008','DD-MON-YYYY')+1,'IW') week_number from dual;
But its not working for the given dates (2nd Jan 2013, which should fall in the last week of 2012, and 6th Jan 2013, which should be the starting week of 2013).
SQL & PL/SQL :: Find Total Sales For The Whole Last Week
Mar 7, 2010I have two columns in table
sales_date
sales_amount
I need to find total sales for the whole last week.
Today is current week i.e. 1 (March 1, 2010 and March 7, 2010)
I need to find total_sales for the last week (i.e. Feb 22, 2010 to Feb 28, 2010)
I am unable to create logic for the same.
PL/SQL :: Selecting Certain Day Of Week From Range Of Dates
Nov 21, 2012I have a table with a count of customers for about a year, but I only want to select Wednesday and Thursday of each week, starting at the beginning of dates. Table is simple and has two columns. Each row is Distinct to a Date, there are no Date duplicates, it's counted for each day of the year.
column 1: count of customers, count(customer_id)
column 2: Date
Not even sure if this is possible to select a date using the day name ?
Basically I want to select each Wednesday and Thursday from each week and compare the counts week over week, over week for all week to see if the counts are going up or down, to get trends .
SQL & PL/SQL :: Change Week Startday To Tuesday
Jan 16, 2012select trunc(to_date('1201090000', 'yymmddHH24mi'),'DAY') from dual
will give output
08-jan-2012 00:00:00
which is sunday as per AMERICA nls_territory setting.
For my requirement i want to group from tue-mon for a week instead of sun-sat. modify the query to use the week start day as Tuesday.
SQL & PL/SQL :: Display Week Number As Per Financial Year (Apr - Mar)
Dec 9, 2012I hava an requirement to get week number from particular date as per indian financial year(ie apr-01 to mar-31).I have tried with to_char(the_date_field,'w') and to_char(the_date_field,'iw') formats but I know its only shows the iso standard.
But I want the weeknumber 1 has to be started from april-01 not from jan-01.For more explanation see below,
Date week_no
apr 01 to 07 1
apr 08 to 14 2
apr 15 to 21 3
.
.
.
.
.
Next year mar - 31 n
how to do this am waiting for your reply.