|
How to write my own function ????????
|
=?GB2312?Q?=D6=EC=B2=A5?=
|
Nov 06, 2002 04:27 PST
|
hi,
I want to know how to write the oracle function and where I can get the help of it!
for example, The following sql is return not null,
" select * from table_a where condition_1= input_condition and ...ˇˇˇˇ", but
" select max(id) ˇˇfrom table_a where condition_1= input_condition and ..."ˇˇ returns null .
if the system could not get the max value of id ,it will return 1 orelse if will return the max value of id!how to write this function or other method to resolve this problem and use the user created function in the SQL?
|
|
 |
|
