ERPstuff - Oracle EBS Community

<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 ...

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 ...

Thanks a lot i understand it Thanks Again.

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 ...

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.

upload it on rapidshare for fast download.


Cheers

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

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

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 ...

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 ...

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

Thanks
Cheers

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 ...

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


Thanks.

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 ...

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.