I am really happy now Monday December 2014 11:14pm
...
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 timewhat you do isscanf(“%*d”...
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')...
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...
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...
Previous Article
Subscribe to:
Posts (Atom)
