tag:blogger.com,1999:blog-34560741.post7888931516315406283..comments2023-11-02T12:22:23.089+03:00Comments on The Momen Blog: Oracle Database 12c - New Feature: Identity ColumnsAsif Momenhttp://www.blogger.com/profile/08802175768050555784noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-34560741.post-59893726669447270362012-11-19T18:29:41.861+03:002012-11-19T18:29:41.861+03:00This is just Vendor conversion play!
DB2 was the ...This is just Vendor conversion play!<br /><br />DB2 was the first of the big 3 to support IDENTITY and SEQUENCE at the same time back around V4, IIRC.<br /><br />SQL Server 2012 supports the SEQUENCE construct.<br /><br />Oracle 12c will now support both.<br /><br />It means that if get get PO'ed with one vendor its easlier to convert to the competitors. <br /><br />DB2 even has PL/SQL Syntax support for Oracle conversions.JAWhttps://www.blogger.com/profile/15716318949841691627noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-455970486083171792012-07-30T15:40:04.899+03:002012-07-30T15:40:04.899+03:00@Ronald,
Yea, the article goes missing from MOS. ...@Ronald,<br /><br />Yea, the article goes missing from MOS. May be it was mistakenly put on by the Support Engineer. :)Asif Momenhttps://www.blogger.com/profile/08802175768050555784noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-46972741204360579202012-07-30T15:31:58.091+03:002012-07-30T15:31:58.091+03:00Can't read the article :-(
Just hoping they do...Can't read the article :-(<br />Just hoping they don't forget about bi-directional replication issues...ronr.blogspot.comhttps://www.blogger.com/profile/09497052323010001266noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-47252764269081144082012-07-26T15:25:22.313+03:002012-07-26T15:25:22.313+03:00Same identity clause as DB2. Hopefully Oracle does...Same identity clause as DB2. Hopefully Oracle does the import and export options for identity columns better compared to DB2.<br />Regards,<br />AndreasAndreashttps://www.blogger.com/profile/11653980235845495184noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-64476553454467949312012-07-25T21:37:27.548+03:002012-07-25T21:37:27.548+03:00Interesting. Nice new feature.
Thanks for sharing!...Interesting. Nice new feature.<br />Thanks for sharing!<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-15905068201341071502012-07-25T20:31:19.569+03:002012-07-25T20:31:19.569+03:00good catch! using sequence was really odd...good catch! using sequence was really odd...Laurent Schneiderhttps://www.blogger.com/profile/13833048234373264017noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-23603541932520942112012-07-25T16:11:27.704+03:002012-07-25T16:11:27.704+03:00I'd much rather see sql booleans. I guess this...I'd much rather see sql booleans. I guess this will make it easier to convert from other databases since most have an identity column.LewisChttps://www.blogger.com/profile/14652008216013571362noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-70505241708889764532012-07-25T13:34:43.944+03:002012-07-25T13:34:43.944+03:00Really interesting, Where we shall use sequences...Really interesting, Where we shall use sequences after 12c?<br /><br />Thanks for share <br /><br />Mahir M. Quluzade<br />www.mahir-quluzade.comMahir M. Quluzadehttps://www.blogger.com/profile/18093992492396019441noreply@blogger.com