hi,
i tried ur code but i need to get the two fields if the value is greater the zero, not the single field.
so please solve the problems quickly
ashokakr
Last Activity: Mar 28 '08, 12:52 PM
Joined: Jul 20 '07
Location:
-
How to get more than one filed in Case Statement
Hi All,
I am new to mysql, can any one help me to solve this problem,
i have a query, based on the condition i have to get two fields from the same table,
how to solve this problem,
select
(case
when hor_val>0 then hor_desc,hor_va l
end) from temp
hor_val is a integer filed, hor_desc is a varchar field,
based on the har_val i have to get... -
Using cursor for update
hi all,
I have a doubt in cursor.Can we use cursor for update query in procedures.
I tried all the cursor concepts but i could not found it, So please help me in giving the syntax for the Update query using Curcor. -
How to add a column to the table
[CODE=sql]
ALTER TABLE castreq ADD COLUMN custno integer DEFAULT 0;
[/CODE]
the value of custno is "CLASS I";
can i use this statement in procudere
my procedure is to add more columns in the table
Please give the correct statement to add a column in procudure -
What is the output statement in PostgreSQL
Hi all
[CODE=sql]
declare
cnt integer;
begin
cnt=5;
dbms_output.put _line(cnt);
end;
[/CODE]
This is my sample procedure, no return type.
when i execute this procedure it shows that
"Syntax error at or near 'dbms_output'"
can any one help me in this problem by giving the correct syntax for the
output statement. -
ok sir,
the datatype for coitem_linenumb er is integer...Leave a comment:
-
"is not scalar Variable" Error
Hi all
This my procedure, when i try to run the procedure it says
"coitem_linenum ber" is not a scalar variable.
Can any one say what is the error and how i can correct it
[CODE=sql]
declare
wotype CHARACTER;
id integer;
so_no ALIAS FOR $1;
_wono integer;
_wolno integer;
woisid integer;
wostdate date;
wosdate date;
woqty integer;...
No activity results to display
Leave a comment: