Search found 74 matches

by najm
Fri Jan 25, 2008 1:59 am
Forum: Oracle Forms & Reports
Topic: Help Required in a Query
Replies: 3
Views: 9299

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....
by najm
Tue Dec 04, 2007 7:12 am
Forum: Oracle Forms & Reports
Topic: Minus Time Query
Replies: 1
Views: 1620

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 ------...
by najm
Tue Oct 23, 2007 2:27 am
Forum: Oracle Forms & Reports
Topic: Record by Per Page
Replies: 2
Views: 2750

Thanks a lot i understand it Thanks Again.
by najm
Thu Oct 04, 2007 2:20 am
Forum: Oracle Forms & Reports
Topic: Record by Per Page
Replies: 2
Views: 2750

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...
by najm
Tue Sep 25, 2007 4:24 am
Forum: Oracle Forms & Reports
Topic: Create User Through Form
Replies: 1
Views: 2505

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.
by najm
Mon Sep 24, 2007 4:51 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Video Tutorials on Oracle General Ledger
Replies: 6
Views: 6085

upload it on rapidshare for fast download.


Cheers
by najm
Mon Sep 17, 2007 3:15 am
Forum: Oracle Forms & Reports
Topic: Order in Group Matrix
Replies: 0
Views: 1310

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
by najm
Mon Sep 10, 2007 5:01 am
Forum: Oracle Projects & Property Manager
Topic: Oracle Connectivity with Attendance Machine System
Replies: 2
Views: 2704

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
by najm
Fri Jul 20, 2007 4:30 am
Forum: Oracle Forms & Reports
Topic: Report Parameter Based on 2 Columns
Replies: 3
Views: 2825

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...
by najm
Tue Jul 17, 2007 2:40 am
Forum: Oracle Forms & Reports
Topic: Report Parameter Based on 2 Columns
Replies: 3
Views: 2825

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...
by najm
Tue Jul 17, 2007 2:28 am
Forum: Oracle Forms & Reports
Topic: Insert Form Trigger in a Report
Replies: 2
Views: 2331

Please let me know how can i do this through srw.do_sql pckage.

Thanks
Cheers
by najm
Thu Jun 21, 2007 6:18 am
Forum: Oracle Forms & Reports
Topic: Insert Form Trigger in a Report
Replies: 2
Views: 2331

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...
by najm
Mon Jun 18, 2007 5:38 am
Forum: Oracle Forms & Reports
Topic: Pictures in a Report
Replies: 2
Views: 2161

I can't Understand please give some more hints or describe it more.


Thanks.
by najm
Mon Jun 18, 2007 1:52 am
Forum: Oracle Forms & Reports
Topic: Pictures in a Report
Replies: 2
Views: 2161

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 ...
by najm
Thu May 31, 2007 2:41 am
Forum: Oracle Forms & Reports
Topic: Error Could not reserver record
Replies: 1
Views: 1693

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.