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,,
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 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
,,,
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.
hi,
i have the following table:
b_no
-------
9
10
11_A
11_B
12
13_A
the b_no is varchar2(7),
i want to get the next item (wich is alaways the number only)
in this example i want to get 14.
regards,,,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.