Forms :: View The Report Between Two Dates
Aug 12, 2010I would like to call out on the report, between two dates through Form But the report is empty.
View 6 Replies
ADVERTISEMENT
Forms :: Running Oracle Report Through 6i And Validating Between Two Dates
Feb 16, 2010I want to call a report through forms 6i and i want to send a parameter from forms6i to report 6i. in which i want to take records between two dates.
View 26 Replies View RelatedFinding Individual Dates Having Dates Plus 2 Days
Jan 26, 2011I want to find the dates which have a date plus with in 2 days after this date. I mean group by 3 days each even the date i missing between two days. Actualy I want to find the start date where the employ was missing on job.
Basic concept is employes have allowed to use 10 personal leaves of a year. Each leave can be use for maximum 3 days.
If employ did not come on the job for one day or two days or three days, it shoul be count as ONE personal leave. And If employ is missing at job for four or five days, it should be count as 2 personal leaves.
seq date
------------------------------
101.01.10
205.01.10
306.01.10
410.01.10
512.01.10
613.01.10
714.01.10
815.01.10
916.01.10
1018.01.10
1119.01.10
1220.01.10
1321.01.10
1423.01.10
1526.01.10
1627.01.10
1729.01.10
1831.01.10
The result should be (Don't use Pl/Sql)
seq date
------------------------------
101.01.10
205.01.10
310.01.10
413.01.10
516.01.10
619.01.10
723.01.10
826.01.10
929.01.10
After finding these days I want to select the starting date of 5th personal leave. (which is 16.01.10).
I am not a expert of using SQL, but I think it could be possible with using partitioning a table on the givin reslult and further partition the reslut on rownum() as rn and the using case statement where rn = 5.
SQL & PL/SQL :: Split A Date Into New Dates According To Black Out Dates?
Mar 10, 2011Split a date into new dates according to black out dates!
Here is my tables:
CREATE TABLE travel
(
start_date,
end_date
)
AS
SELECT DATE '0000-01-01', DATE '9999-12-31' FROM DUAL;
[code]....
I have lets say a "travel date" and black out dates. I will split the travel date into pieces according to the black out dates.
Note: Travel Date can be between 0000-01-01 - 9999 12 31
Sample:
Travel Date:
Travel | START DATE | END DATE
T | 2011 01 04 | 2011 12 11
Black Out Dates:
BO | START DATE | END DATE
A | 2010 11 01 | 2011 02 11
B | 2011 01 20 | 2011 02 15
C | 2011 03 13 | 2011 04 10
D | 2011 03 20 | 2011 06 29
Excepted Result:
New Travel | START DATE | END DATE
X1 | 2011 02 16 | 2011 03 12
X2 | 2011 06 30 | 2011 12 11
Visually:
Travel Date : -----[--------------------------]--
A : --[------]-------------------------
B : ------[---]------------------------
C : --------------[---]----------------
D : ----------------[------]-----------
Result :
X1 : -----------[--]--------------------
X2 : -----------------------[--------]--
Sample 2:
Travel Date : -[--------------------------------]--
BO Date A : ----[------]-------------------------
BO Date B : -------------------------[---]-------
BO Date C : ----------------[---]----------------
BO Date D : ------------------[------]-----------
Result X1 : -[-]-------------------------------
Result X2 : -----------[--]--------------------
Result X3 : -----------------------------[--]--
How can I do it using PL SQL ?
Reports & Discoverer :: Group Report From View Sort Differently?
May 20, 2011I encountering while giving ORDER BY CLASS at report query.
View was created from Master and Detail table with simple join after this i created group above report with order by ID (Varchar2 , Values like 0010101001) but in report it order ruffly( not ascending or descending but randomly) .
Application Express :: Default To Icon View Only For Interactive Report
Sep 11, 2012I am developing a Catalog style application and displaying pictures in an Interactive Report; I can get the Interactive Report to display the Icon view when users visit the report the first time, the report works pretty simply. It has a series of buttons for the Sections of the Catalog and when the user presses the button it fills a hidden item which is in the where criteria of the Catalog, all of this works great with one exception:
When the user clicks the Catalog button and the data in the Interactive Report Changes; the Report changes to "Report View" I would like to maintain the report in "Icon View" only is there a way how I could have the interactive report only show "Icon View".
SQL & PL/SQL :: Forms 6i - Compare Start And End Dates
Feb 6, 2011I am comparing the dates in forms 6i.I need to compare the start and end dates and if the date are getting than an year then i need to get an error message.
View 2 Replies View RelatedForms :: Data Between Dates But Parameter Not Working And Showing All?
May 4, 2011i am seting runtime where clause on Forms as follow:
set_block_property('FORMC', onetime_where,'where to_char(INVOICE_DATE,'||'DD-MON-YYYY'||') >='||'to_date('||:search.inv_frm||','||'DD-MON-YYYY'||')'||
' and to_char(INVOICE_DATE,'||'DD-MON-YYYY'||') <' || 'to_date('||:search.inv_to||','||'DD-MON-YYYY'||')');
:search.inv_from is from date
:search.inv_to is up to date
i wann data between this dates but date parameter is not working it showing all data...... where synatx get wrong..
Select All Dates Between Two Dates
Oct 22, 2003How can I select all of the dates between two dates? For example, given the start date 12/2/2003 and the end date 12/5/2003 I want to return:
12/2/2003
12/3/2003
12/4/2003
12/5/2003
Is there a built in function for this? Is there a way for a function to return multiple rows? It has to be a function because I need to use it within other SQL statements.
Forms :: Create View Based On Values Selected In Forms
Jun 7, 2013I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.
Forms :: Saving Form To View On Web
Jan 26, 2010i have developed a form in 9i. can i view the fmx file on web. or tell me the extenstion what name of form should i use to save the form to view on the web.
View 5 Replies View RelatedForms :: Unable To View Icons?
Feb 20, 2010When form is run through developer icons are viewed.
when calling same form through URL enable to view icons.
Forms :: Using Data Grid View In 6i?
Jan 26, 2010Is it possible to use Data grid view in Forms6i just as in Visual Basic?
View 7 Replies View RelatedForms :: View Based Form
May 7, 2013i have a form based on view just to display. when i execute query,records are getting displayed more than once. make them get displayed just once.
View 12 Replies View RelatedForms :: ORA-00942 - Table Or View Does Not Exist
Jun 8, 2011The form actually consists of one block that refers to a table in DB(Datablock). The functionality of the form is to run some logic and then just insert data in the table .This happens on press of a button.
The problem is when I run the form thru' Admin Id it runs successfully but when I run the form through some other user it gives me the error.
The grants on the table are Public. GRANT DELETE, INSERT, SELECT, UPDATE ON XYZ TO PUBLIC;
Forms :: Code Of Creating View In Pre_Form
Nov 25, 2010Following
create or replace view dept_list as
select 1 state, 1 depth, 'DEPARTMENT' displ_value, null icn, null pk, 'A' sort_value
from dual
union
select -1 state, 2 depth, dname displ_value, null icn, null pk, 'A' sort_value
from dept
union
select -1 state, 3 depth, 'EMPLOYEES' displ_value, null icn, null pk, 'A' sort_value
from dept;
is placed in Pre_Form Trigger it generated error.
Error 103 at line 1, column 1
Encountered the symbol "create" when expected the following.
Server Administration :: How To Change Existing Materialized View To Normal View
Jan 17, 2013can we change the existing materialized view to normal view? if yes how?
View 2 Replies View RelatedForms :: Retreive Image From Database And View Oracle 6i Form
Jun 24, 2012i save image in oracle databse but how can i call this image another form of oracle 6i froms
View 1 Replies View RelatedForms :: Run Report From 10g?
Sep 21, 2011Oracle 10g Developer suite / using OC4J run report from form with and without passing parameters.
View 5 Replies View RelatedCreating Materialized View On Remote Simple View
Dec 11, 2012I'm trying to create a Materialized View on a remote database from a simple view. The reason is, the data owners don't want to grant explicit tables privileges to external subscribers.
A new schema is created to publish data in the form of a view. I've created mlogs on the master tables, and granted them to the subscriber, but it's still complaining about a missing primary key on the view. A primary key does exist in the master table.
Is there another work around for this situation without having to work inside the data sources' environment?
SQL & PL/SQL :: Create Primary Key On View And Use This View For Creating Foreign Key?
Oct 8, 2010is it possible to create primary key on view and use this view for creating foreign key .
View 3 Replies View RelatedSQL & PL/SQL :: Change View Definition When Select Is Running On That View
Apr 25, 2012We wrote one data load process to load GZ files into Database.during process we will change client facing view definitions to backup table so that we can work on base tables.
This view definition changes are related to FROM and WHERE clause (not columns/type). during load process, client/user may connect to current server and accessing these views. My question is what will be the reflection of changing view definition while user is accessing view?
I created a scenario-
STEP1: Created a view-
create or replace view view_01 as
select object_name from dba_objects union all
select object_name from dba_objects union all
select object_name from dba_objects union all
[code]....
View definition is replaced by new definition while select is executing on that view. select returned number of records as per view definition one.
Forms :: Call Report From 10g
Feb 1, 2012I have a form and i want to call report name is " DOCK_RECEIPT". I already create parameter report on this Form name is " REPORT82" and set property this parameter report contain {Name is REPORT82, filename is DOCK_RECEIPT.rdf, execution Mode is Batch, Communication Mode is Synchronous}. I also create a procedure name is F_PRO_PRINT follow:
PROCEDURE F_PRO_PRINT IS
pl_id ParamList;
rep_id REPORT_OBJECT;
V_rep VARCHAR2(100);
rep_status VARCHAR2(20);
rep_job_id varchar2(100);
v_mine_type varchar2(50);
v_palletid NUMBER(10):=0;
[code]...
Now i have button and in trigger when-button-press add this code call procedure above
F_PRO_PRINT;
When i click button call report and appear error.
FRM-41214: Unable to run report
Now, i want to call report from form 10g.
Forms :: Report Run From Menu
Dec 7, 2010I am using Developer 10g R2. From menu module i want to check the status of the report server. also when the status is shutdown then reportserver will be start otherwise run the report.
Programatically how can i do this.
Forms :: Report Scheduling?
Jan 23, 2011how to do report scheduling.? So that server can auto run those report at specified time. And send output to user.
View 2 Replies View RelatedForms :: Call Report From 11g
Dec 26, 2010i need call report from forms 11g..Example or Code I have a forms11g and system XP.
View 7 Replies View RelatedSQL & PL/SQL :: Oracle View Have Dynamic View Function?
Jul 28, 2010Are oracle view have Dynamic view function?
View 8 Replies View RelatedSQL & PL/SQL :: Materialized View - Table Or View Does Not Exist
May 2, 2012I have a materialized view "pro_mview",I am trying to refresh the MVIEW by using the following statement.
EXEC DBMS_MVIEW.REFRESH('pro_mview','C');
But I am getting the below error.
*
Error at line 1:
ORA-12008: error in materialized view refresh path
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431
ORA-06512: at line 1
I am able to fetch the data from that materialized view(pro_mview).
Forms :: Use Of DB Link In D2K Form And Report 6i?
Sep 16, 2010how to use of Database link (DBLINK) in D2K form and report PL/SQL.When I Use the DB Link in Pl/SQL of any form6i or report 6i, On compilation forms and reports are automatically closed.
View 3 Replies View RelatedForms :: Frm-41214 - Unable To Run Report
Sep 26, 2008i tried to run the report from form in oracle forms 10g, its raising the below errors:-
frm-41214: unable to run report.
on the same time, i have successfully run the report, which one is developed newly.
problem raising report is migrated from 6i to 10g.
my os xp, db is 10g, forms and reports is 10g
