write a procedure to print a statement or number not
using "dbms_output.put_line" package.write a procedure
instead of it using procdure name as "print"
ex:-
declare
a number:=2;
begin
print(a);
end;
/* when U type above procedure 2 have to should be printed*/
If i can use sys.check_constraints to display my constraints
from my database using sql server 2005, how can i display
then if i am using sql server 2000????
234
I have done oracle 10g. I need a project knowledge. So if u
please send a project how it should be done,Or you can send
email link. I will be very grateful to u.
5
GLOBAL TEMPORARY TABLE over Views in advantages insolving
mutating error?
a table has 2 classifications
1)liabilities
2)earnings
this liabitity has 2 elements with 2 input values
and
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
liabilities,amount1,savings,amount2
xxxx xxxxxx
xxx1 xxxxx1
yyyy yyyy
yyy1 yyy1
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution
To Refer this Site to Your Friends 
Site Map
