Re: SQL Question


"dean" <deanbrown3d@xxxxxxxxx> wrote in message
news:1140796547.138923.33420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
: Sorry I don't know anything about OCI - we used it years ago in low
: level programming calls but not any more. How can I tell?
:
: Is there no simple SQL query I can run as a select statement from dual,
: or something like that?
:
: Thanks!
:
: Dean
:

what are you using to establish the connection with the Oracle database?

what grid are you using?

likely it's a grid property

there is no such message or select statement to submit to oracle -- if you
were coding PL/SQL or issuing your own SQL statements, you could check
SQL%ROWCOUNT (or ROWCOUNT for a specific variable) or depending on the
environment you issue your SQL from check the SQLCA (IIRC -- it's been
awhile)

but if you're using a grid control, the grid control is managing the SQL for
you, and it will be reponsible for returning the status

so i'm guessing really isn't an oracle question but a grig control question

++ mcs


.

Relevant Pages

  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: MS SQL Server - a plethora of limitations...
    ... > Most of your objections are that MS-SQL is not Oracle. ... according to the standards. ... > There is no such syntax or concept in Standard SQL. ... Partitioning shouldn't be done automatically by the DB, ...
    (microsoft.public.sqlserver.programming)