[devrishitrehan]

Hi,

I am trying to fire a query from SQL Servlet using WITH Clause

WITH sg as
(select * from shipment)
select count(*) from sg

It is showing

Confirmation
The result of the operation is 1.

But it is not showing the result of the query.
I have tried to use spreadsheet output option but getting same results.

Please inform how can I see the output.

Thanks in advnace.

Dev

tredev@gmail.com

[cunninghamg]

Dev
I'm not sure what sql you're used to but thats not Oracle sql.

The statement
select count(*) from shipment

will get you the result you require

Gary

[devrishitrehan]

Thanks Gary,
I have shown here an example only using WITH clause.
Same sql is giving me output in SQL DEVELOPER,Oracle Sql Plus and other interfaces.

So wanted to know the way to display results from OTM Sql servlet as it is displaying confirmation message only.

Many Many Thanks,
Dev