Search found 74 matches
- Fri Jan 25, 2008 1:59 am
- Forum: Oracle Forms & Reports
- Topic: Help Required in a Query
- Replies: 3
- Views: 10280
Help Required in a Query
<b>Class TABLE</b> SNO TNO MARKS GRADE <b>TERM TABLE</b> TNO TERM TERMSTATUS <b>SELECT * FROM TERM</b> TNO TERM TS --- ---------- --- 26 SPRING 2006 27 SUMMER 2006 28 FALL 2006 0 EXEMPTIONS 29 SPRING 2007 30 SUMMER 2007 31 FALL 2007 32 SPRING 2008 C <b>Query is </b> SELECT C.SNO, T.TERM, C.MARKS, C....
- Tue Dec 04, 2007 7:12 am
- Forum: Oracle Forms & Reports
- Topic: Minus Time Query
- Replies: 1
- Views: 2030
Minus Time Query
Dear I have a query DESC REGISTER NAME TYPE --------- ---------- EMP_ID NUMBER(10) EMPCODE VARCHAR(10) TIME_IN DATE DUTYTIME_IN VARCHAR2(10) TIMEIN_DIFF NUMBER(5) SELECT EMP_ID, EMPCODE, TIME_IN , DUTYTIME_IN, TIMEIN_DIFF FROM REGISTER; Result Shows EMP_ID EMPCODE TIME_IN DUTYTIME TIMEIN_DIFF ------...
- Tue Oct 23, 2007 2:27 am
- Forum: Oracle Forms & Reports
- Topic: Record by Per Page
- Replies: 2
- Views: 3406
- Thu Oct 04, 2007 2:20 am
- Forum: Oracle Forms & Reports
- Topic: Record by Per Page
- Replies: 2
- Views: 3406
Record by Per Page
Dear i have report in which their is 2 queryes i want the result of both queryes on a single pages i attach an example report link please check and advice me. 2 Links are attached for download Right Click and Save Target As.. http://www.orafaq.com/forum/fa/3176/85724/ http://rapidshare.com/files/601...
- Tue Sep 25, 2007 4:24 am
- Forum: Oracle Forms & Reports
- Topic: Create User Through Form
- Replies: 1
- Views: 2906
Create User Through Form
Dear I want to write this line on
<b>when button pressed </b> Trigger
Grant DBA to ABC Identified by ABC
and then i connect this user to SQL for writing query.
<b>when button pressed </b> Trigger
Grant DBA to ABC Identified by ABC
and then i connect this user to SQL for writing query.
- Mon Sep 24, 2007 4:51 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Video Tutorials on Oracle General Ledger
- Replies: 6
- Views: 6560
- Mon Sep 17, 2007 3:15 am
- Forum: Oracle Forms & Reports
- Topic: Order in Group Matrix
- Replies: 0
- Views: 1707
Order in Group Matrix
Dear all I have a Problem which is i want to order by through lexical in a Group Matrix Report i use all the ways to do but not succeed can any one have an idea.
Thanks
Cheers
Thanks
Cheers
- Mon Sep 10, 2007 5:01 am
- Forum: Oracle Projects & Property Manager
- Topic: Oracle Connectivity with Attendance Machine System
- Replies: 2
- Views: 3148
Oracle Connectivity with Attendance Machine System
Dear
We have Attendance System on Completely Microsoft Access base by which we have too much difficulty to manage so that we want to convert it to Oracle and Oracle Developer is it possible to convert easily or what accessories we have to do.
Thanks
Cheers
We have Attendance System on Completely Microsoft Access base by which we have too much difficulty to manage so that we want to convert it to Oracle and Oracle Developer is it possible to convert easily or what accessories we have to do.
Thanks
Cheers
- Fri Jul 20, 2007 4:30 am
- Forum: Oracle Forms & Reports
- Topic: Report Parameter Based on 2 Columns
- Replies: 3
- Views: 3494
Exactly I want as you say my query is select * from emp where sal > 2000 or where Comm > 500 then i use both 2 fields in a parameter SAL COMM when i select SAL this query show result select * from emp where sal > 2000 and when i select COMM this query show result select * from emp where COMM > 500 I...
- Tue Jul 17, 2007 2:40 am
- Forum: Oracle Forms & Reports
- Topic: Report Parameter Based on 2 Columns
- Replies: 3
- Views: 3494
Report Parameter Based on 2 Columns
Dears I have a Report in which i have 1 Parameters in this report i want data as on my requirement like select * from emp; EMPNO ENAME MGR SAL COMM DEPTNO --------- ---------- --------- --------- --------- --------- 7369 SMITH 7902 800 20 7499 ALLEN 7698 1600 300 30 7521 WARD 7698 1250 500 30 7566 J...
- Tue Jul 17, 2007 2:28 am
- Forum: Oracle Forms & Reports
- Topic: Insert Form Trigger in a Report
- Replies: 2
- Views: 2972
- Thu Jun 21, 2007 6:18 am
- Forum: Oracle Forms & Reports
- Topic: Insert Form Trigger in a Report
- Replies: 2
- Views: 2972
Insert Form Trigger in a Report
Dear I have a trigger in a Form (When-Button-Pressed) i want to use this Trigger on a button on Report runtime My tigger is DECLARE CURSOR C1 IS SELECT NEW.CID,NEW.SNO,NEW.MT,GS.GP,GS.GRADE,c.CRHOURS chr, GS.GP*c.CRHOURS tp FROM GRADING_SYSTEM GS,myclass my,course c,( SELECT CA.CID,CA.SNO,CEIL(NVL(S...
- Mon Jun 18, 2007 5:38 am
- Forum: Oracle Forms & Reports
- Topic: Pictures in a Report
- Replies: 2
- Views: 2821
- Mon Jun 18, 2007 1:52 am
- Forum: Oracle Forms & Reports
- Topic: Pictures in a Report
- Replies: 2
- Views: 2821
Pictures in a Report
Dear I have report in which i call a Picture in a Report which is based on Employee Id their is a little problem is that when their is no picture of any employee the message comes 'REP-0108: File not found' but if their is picture report runs successfully i want if their is no picture then their is ...
- Thu May 31, 2007 2:41 am
- Forum: Oracle Forms & Reports
- Topic: Error Could not reserver record
- Replies: 1
- Views: 2130
Error Could not reserver record
I face following error very frequently in my Database
<b>Could not reserver record (2 tries). keeb trying?</b>
i know why it show but i want to know how fix it.
Thanks.
<b>Could not reserver record (2 tries). keeb trying?</b>
i know why it show but i want to know how fix it.
Thanks.