Recent content by nouf

hi.. how can i put the sum of salary in the report accumulated. means the first page contains the sum of all salaries in the page and the second page contains the sum of all salaries of the first and the second page and so on..

Hi.. is there any function or procedure to resd directly from an excel sheet and insert into a table?

hi,, please any one can help me in doing the following: i have two tables dept_code d_name --------- ------ 1 aa 2 bb 3 cc sec_code dept_code s_name ---------------------------- 1 3 ss1 2 1 ss2 3 3 ss2 i...

HI,, I WANT TO KNOW IF I CAN CREATE VIEW WITH CASES, FOR EXAMPLE IF I HAVE FOUR TABLES LIKE THE FOLLOWING EMPLOYEE TABLE --------------- EMP_CODE EMP_NAME DEPT_CODE SEC_CODE -------- -------- --------- -------- 1 EMP1 2 2 2 EMP2 1001 1002 3 EMP3...

HI,, I WANT TO DEVIDE A STRING INTO SUBSTRINGS LIKE THE FOLLOWING MAIN STRING 'HI IAM NOUF' ---- I WANT OT DEVIDE IT INTO HI IAM NOUF

i want to display the date into arabic format for example saturday 1-jun-04 = ????? 1-?????-04

hi,, i want to run a VB application through an oracle form .. please help me to do that

HI THERE ,, I WANT TO KNOW HOW TO RUN A CHART BUILT BY GRAPHICS BUILDER, USING A BUTTON IN A FORM IN FORM BUILDER ...

if i have data in sql server databas how can i retrieve those data into oracle and how can i show it in a form written in oracle form builder..

HI, I MAD A FORM , AND IN THE FIRST FIEL I MAD A TRIGGER TO CHECK ITS VALUE THE TRIGGER IS (WHEN VALIDATE ITEM ): ------ IF :CONTROL.WO_NO IS NULL THEN SHOW_MESSAGE('WO_NO CAN'T BE NULL'); RAISE FORM_TRIGGER_FAILURE; END IF; ---- THE PROBLEM IS WHEN I TRY TO CLOSE THE FORM BY A BUTTON WHICH I...

to santamufasa: thank you very much it is working well now....

THE ERROR ORA-01722: invalid number APPEARS WHEN I USE TO_NUMBER NOT ABOUT TRANSLATE.... ALSO I MAY USE ALL CHARACTERS IN (_X)

To SantaMufasa ,,, first of all in my field i may have 15_B also not only A is used,, also when i use [ order by to_number(.....) ] in developer it gives me an error about it. i used your code but ther was an error which is : ORA-01722: invalid number (about translate) so can you help please;

hi, i have the following table b_no ----- 9 11 10_A 13 14 15_A 16 b_no is a varchar2(7) field,,i want 1- to order this field to get b_no ------ 9 10_A 11 13 14 15_A 16 2- to get the next sequence of the b_no ,her i want 17.

to sem,,,, thank you very much, it is working..