Re: procedure in oracle
mou lei wrote:
> I have a procedure in oralce
>
> begin
> v_row table%ROWTYPE;--how can i declare this in
> mysql
> end;
>
mmm I doubt it, In oracle it would be:
declare
v_row table%ROWTYPE;--how can i declare this in
begin
null;
end;
anyway - MySQL does not support the %TYPE or %ROWTYPE syntax. You will just have to declare as many inidividual variables as you need.
> another problem is
> the function NVL in oracle
> can i find some insead in mysql?
>
> thanks a lot
for
NVL(a,b)
use
COALESCE(a,b)
(which is defined in the SQL Standard)
or
IFNULL(a,b)
Subject
Views
Written By
Posted
2983
March 17, 2006 01:23AM
Re: procedure in oracle
2235
March 17, 2006 02:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.