Skip to main content

Oracl Sql support

  • September 20, 2013
  • 1 reply
  • 8 views

Nassim_Kasdali
Hi, i'm wondering if vertica support all the oracle SQL function ? for exemple; with as or start as ? regards.

1 reply

Daniel_Leybovic
Forum|alt.badge.img+1
Hi! >> i'm wondering if vertica support all the oracle SQL function. Vertica supports for standard SQL functions with additional advanced analytic functions. If ORACLE function isn't in standard, probably that not - Vertica doesn't support it. >> for exemple; with as or start as ? WITH AS and START AS - it is not functions, it's statement/clause. Vertica has limited support for WITH clause: https://my.vertica.com/docs/6.1.x/HTML/index.htm#19410.htm PS For ORACLE functions that you can't find in Vertica you can take a look here: https://github.com/vertica/Vertica-Extension-Packages