Hi All,

Can some one brief me the limitations of the "SQL Queries which we write in LN tools" versus "Queries we write in RDMBS" softwares like TOAD etc.


Thanks in Advance,
Rajitha

Hi,

Do you have any specific reason for checking the limitations? There might be number of limitations, to note a few-

1. You can't use Case inside a select in Easy SQL Query(though its possible in the scripts with some tricks)

2. You can't bind variable using alias. Binding is only possible with MIN,MAX,SUM,AVG