Welcome to the home of one of Cincinnati's premier professional organizations, the Greater Cincinnati Oracle User Group (GCOUG). ABOUT US...

Sponsor GCOUG


Big Thanks to our Meeting Sponsors!


Vendor Sponsors Links

Ensure that a devoted audience of Oracle users sees your products via website advertising on the homepage of www.gcoug.org. This highly visible promotional vehicle enables your message to achieve a solid ROI for your campaign. Lean more by downloading the sponsorship brochure above.

Upcoming Meeting


No events to display at this time. Check back soon!

Ask Tom

  • Finding the number of rows in each table by a single sql

    hi tom i have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from......

  • Difference between Full Index Scans and Fast Full Index Scans

    Hi Tom, What is the difference between Fast Index Scan and Fast Full Index Scan ? As per oracle documentation, A full scan is available if a predicate references one of the columns in the index. The predicate does not need to be an index ...

  • IN (vs) EXISTS and NOT IN (vs) NOT EXISTS

    Hi Tom, Can you pls explain the diff between IN and EXISTS and NOT IN and NOT EXISTS. Because I have read that EXISTS will work better than IN and NOT EXISTS will work better than NOT IN (read this is Oracle server tunning). Regard...

  • ORA-12560: TNS:protocol adapter error

    i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating ORA-12560: TNS:protocol adapter error what should i do? please help.. ...

  • Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors

ONT Security Alerts