Announcement

Collapse
No announcement yet.

With clause not supported in OTM Sql Servlet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • With clause not supported in OTM Sql Servlet

    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

    [email protected]

  • #2
    Re: With clause not supported in OTM Sql Servlet

    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
    Regards
    Gary Cunningham
    www.cbmc.co.uk
    www.mavenwire.com

    Comment


    • #3
      Re: With clause not supported in OTM Sql Servlet

      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

      Comment

      Working...
      X