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!


               Blue Ash YMCA


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!

From the Blog

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......

  • 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

  • How to connect SQLPlus without tnsnames.ora

    Hi I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my tnsnames.ora POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(H...

ONT Security Alerts