SQL Developer SQL Server Migration Creates Trigger/sequence Instead Of Identity For Temp Tables
(Doc ID 2684836.1)
Last updated on JULY 21, 2020
Applies to:Oracle SQL Developer - Version 19.2 and later
Information in this document applies to any platform.
SQL Developer SQL Server Migration creates trigger/sequence instead of identity for Temp Tables.
Having normal tables in a SQLServer with identity columns and having Oracle
12c code generation checked SQL Developer correctly creates in Oracle
identity columns. But having a temp table in Oracle which is for example
created during a procedure call the SQL Server code is translated into the
old syntax using trigger & sequence
Same happens also with function that have a temp table definition inside:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document