Finally I got Google + Adsense account

I am really happy now Monday December 2014 11:14pm

[Read More...]

Secrets of C Language Codes

1. A C program which can print the file name it is kept in ;) .
#include<stdio.h>
main(){
printf(“the source file name is %s\n”,__FILE__);
}

2.
int dummy;
scanf(“%d”,&dummy);
but there is one more method which can save memory and time
what you do is
scanf(“%*d”);

[Read More...]

Oracle Reports - Bill Payment

select  x.sl_no,x.regno,y.name,upper(y.address) address,Y.DOTE_REGNO,
decode (y.course,
'CIVIL', 'Diploma in Civil Engineering',
'DME','Diploma in Mechanical Engineering',
'EEE','Diploma in Electrical & Electronics Engineering',
'ECE' ,'Diploma in Electronics & Communication Engineering',
'CSE','Diploma in Computer Engineering') course,
y.current_sem current_sem,y.scheme,
x.sem,
--'   '||x.particula
'   '||DECODE (Y.CATEGORY,'SC',(DECODE(x.particulars,'SEM_FEE','MISC_FEE',X.PARTICULARS)),X.PARTICULARS) PARTICULARS,
x.bill_no,x.bill_date,
x.actual_fee,x.amount,x.balance,x.created_by,x.created_on,x.parity
from
tb_billing x,
tb_personal y

where x.regno = y.regno
AND X.bill_date = :Today_Receipt
--and x.bill_no = 14475
order by x.parity

[Read More...]

Oracle Forms - Accounts Checklist

select '  '||name, regno,course, scheme ,current_sem,sl_no,bill_no,sem,bill_date,        '  '||particulars,
amount ,actual_fee,balance,cheque
from (
select y.name name,x.bill_date,x.bill_no, x.sem,
rank() over (partition by x.bill_date order by x.bill_no) as sl_no,
x.particulars,x.amount,x.regno,
y.course,
x.cheque cheque,
decode (y.current_sem,'I','I','II','I','III','II','IV','II','V','III','VI','III')  current_sem,
y.scheme,
X.ACTUAL_FEE actual_fee,X.BALANCE balance
from tb_billing x, tb_personal y
where x.regno = y.regno (+)
and x.bill_date = :Enter_Bill_date
)
 order by bill_date desc,bill_no

[Read More...]

Oracle Reports - Row/Columnwise Table Result

select signature,a,
S_EXAM_DATE,
s_sess_id,
paper_name,code,s_branch,s_semester,
count(b) ct,
max(decode(b,1,regno)) row1,
max(decode(b,2,regno)) row2,
max(decode(b,3,regno)) row3,
max(decode(b,4,regno)) row4,
max(decode(b,5,regno)) row5,
max(decode(b,6,regno)) row6,
max(decode(b,7,regno)) row7
from
(select * from f_x  ORDER BY REGNO)
group by signature,a ,s_exam_date,s_sess_id,paper_name,
code,s_branch,s_semester
order by a

[Read More...]