Does HP Vertica fully supports ORACLE for queries ???

Does HP Vertica fully supports ORACLE for queries ??? I am not able to fire a below query: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='VMartDB' Which syntax does HP Vertica follow ??


  • Options
    Hello Syed, It's not clear what you mean when you request "full support" of Oracle queries. The SQL syntax is largely the same and the most commonly used catalog tables are also mostly compatible. However, some queries may need to be modified to work with Vertica if they previously worked with Oracle's database product. Please see the documentation for each case. Here is the documentation page for v_catalog.all_tables: https://my.vertica.com/docs/6.1.x/HTML/index.htm#16818.htm v_catalog.tables has more information, including owner information: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12276.htm
  • Options
    Navin_CNavin_C Vertica Customer
    Hello Syed, The above query will work this way. SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER_NAME='VMartDB' Hope this helps..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file