Does HP Vertica fully supports ORACLE for queries ???

Syed_Mohammad_M

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

[Deleted User]

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

Navin_C

Hello Syed, The above query will work this way. SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER_NAME='VMartDB' Hope this helps..