Am using below query, but it is not working.

select record_id,

if Col1= 'Student'

Begin

Insert record_id, Student as Stud into new_table

end

else if Col2 = 'Student'

Begin

Insert record_id, Student as Stud into new_table

end

else if...

hi,

as per my requeirement when ever i insert new record, existing record should be deleted.

Hi,

Function is working fine,

but when ever i call the function, it should return single value only,

if i call 10 times - 10 alphanumeric values should be written in...

Thank U Boss,

It is looking great...

but i need every record should have a numeric and alpabet,

in present code, some records are only alphabetic....

in query trying for 1000,

but i need max.

if it is more than 36*36*36*36, it helps me a lot...

Below code is working in 'Oracle'

i need same output in sql.....

with digits as

( select n, chr(mod(n,36)+case when mod(n,36) < 10 then 48 else 55 end) d

from (Select rownum-1...

Hi,

not exactly like home work, as per my requirement only am posting.

i've tried below code, but it is generating only number.

WITH Sequence ( SeqNo) as

(

...