You write this query.... select * from emp where (sal between :p_losal and :p_hisal or (:p_losal is null or :p_hisal is null)) and (deptno =:p_Deptno or :p_deptNo is Null) i think i will resolve you problem but still problem exist please reply or call me Best regards, R E H A N M I R Z A System Anal...
Mr. Admin i was send you scirpt yesterday, but there is not reply ???? please audit it and reply promptly. According to me it work well bu i need some one else audit it.............. Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray P...
Assalam-o-Alaikum Basicly it work well but i am fist time use same table for IN and OUT transaction....... i want some one audit it and tell me if any problem exists..... I give you create table statements but in this many foreign keys available which disturb u there is not attachmen option so i wil...
Assalam-o-Alaikum I got working project of my client someone work on that project but unfortunatly he leave this project so i got it. He use same tables for In and Out SQL> desc enInOut_M Name Null? Type ----------------------------------------- -------- ------------- TRNO NOT NULL VARCHAR2(13) REFT...
Assalam-o-Alaikum thank you very much for you kind help, i got IP_Address of machie, but this query fails SQL> SELECT sys_context('USERENV', 'OS_USER') FROM dual; SELECT sys_context('USERENV', 'OS_USER') FROM dual * ERROR at line 1: ORA-02003: invalid USERENV parameter waiting from your repaly for H...
Assalam-o-Alaikum Nigar please give me yours email address i will send you placeholder column example...... Placeholder column is a column in which you can assign a value through query for example you create report of exployee you need to disply his department and location. you write code for dname ...