tag:blogger.com,1999:blog-8873109125023142810.post3083689927035303031..comments2024-03-29T06:56:24.360+05:30Comments on Let's Develop in Oracle: Oracle Database 12c New Features for DevelopersNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-8873109125023142810.post-82032093213358899552017-08-21T19:32:46.780+05:302017-08-21T19:32:46.780+05:30very useful and handy i have few questions between...very useful and handy i have few questions between sequence and identity columns .<br />where sequence can generate the numbers as per your requirement based on increment value.<br />where as identity column will increment the value.<br />Apart from this any difference are there in using irrespective to above comments Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-90267469272689678632017-06-18T11:23:27.192+05:302017-06-18T11:23:27.192+05:30You should look at the Oracle 12c R2 features too,...You should look at the Oracle 12c R2 features too, amazing list<br />http://nimishgarg.blogspot.in/2016/10/top-15-new-features-of-oracle-database.htmlNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-1657375656500539072017-06-17T22:00:14.100+05:302017-06-17T22:00:14.100+05:30Wonderful, being an Oracle developer for over 14 y...Wonderful, being an Oracle developer for over 14 years, I was always thinking about why Oracle is not providing these features and finally they are out.<br />Sequence as Default Value<br />VARCHAR2 length up to 32767<br />Top-N feature, would be a beauty if this works with group by too. I have not checked it yet.<br />IDENTITY Columns<br /><br />I am now eagerly waiting for my customer to upgrade with 12c. venkathttps://www.blogger.com/profile/03455785265974519337noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-28728359285969619662017-03-28T19:37:20.879+05:302017-03-28T19:37:20.879+05:30Very useful
Just for point 8 (Cascade for TRUNCATE...Very useful<br />Just for point 8 (Cascade for TRUNCATE) worth mentioning, that the foreign key constraint should be created with on delete cascade, then only truncate cascade will work.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-6876204808982688992017-03-07T15:48:45.432+05:302017-03-07T15:48:45.432+05:30Really quick way to refer list of new features. th...Really quick way to refer list of new features. thank youoraclebloghttps://www.blogger.com/profile/07351867158123321822noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-33787839655864633072016-07-17T09:35:22.705+05:302016-07-17T09:35:22.705+05:30Thanks for consolidated list of 12c featuresThanks for consolidated list of 12c featuresVikram Brahmacharinoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-55972426091705189182015-12-02T14:34:10.573+05:302015-12-02T14:34:10.573+05:30very very usefull and handy.. thanks for sharingvery very usefull and handy.. thanks for sharingShobha Hegdehttps://www.blogger.com/profile/03395194759735780535noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-40837720121257718762015-11-23T11:05:04.116+05:302015-11-23T11:05:04.116+05:30very nice info
very nice info<br />Anonymoushttps://www.blogger.com/profile/13137390434739625669noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-6743288778131349702015-11-13T00:15:40.946+05:302015-11-13T00:15:40.946+05:30amazing, very useful information....amazing, very useful information....Mukesh Kumarhttps://www.blogger.com/profile/06590946151346751463noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-47356673656402414152015-07-18T22:22:26.946+05:302015-07-18T22:22:26.946+05:30Useful information. Thanks for sharing.Useful information. Thanks for sharing.Bhanuhttps://www.blogger.com/profile/01188679401892978050noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-90146030378342739202015-02-17T20:08:46.462+05:302015-02-17T20:08:46.462+05:30Good information. Thank you.Good information. Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-86275148090398772552014-08-19T04:10:39.898+05:302014-08-19T04:10:39.898+05:30oh my god really you are amazing, many thank
wale...oh my god really you are amazing, many thank<br /><br />waleed fetohAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-19937764620150527412014-07-09T20:11:57.474+05:302014-07-09T20:11:57.474+05:30wonderful information...Thank you very much..!!wonderful information...Thank you very much..!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-26396879058701170272014-05-21T05:51:07.913+05:302014-05-21T05:51:07.913+05:30Very useful information. Thank you so muchVery useful information. Thank you so muchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-32244723142215097892013-12-03T18:31:10.639+05:302013-12-03T18:31:10.639+05:30Excellent Documents..it's really helpful.Excellent Documents..it's really helpful. Anonymoushttps://www.blogger.com/profile/09775701370984135260noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-58683793470246200122013-10-04T15:26:36.299+05:302013-10-04T15:26:36.299+05:30Excellent Stuff...Excellent Stuff...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-69432514008833409882013-09-29T18:44:48.153+05:302013-09-29T18:44:48.153+05:30I think it is better to export the entire table an...I think it is better to export the entire table and perform the import i.e entire data is stored in a single block and now the table performance will increase...later u can add another column easily...KISHORE.Unoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-68732321311611190082013-09-29T18:42:15.850+05:302013-09-29T18:42:15.850+05:30Easily to Understand...
Nice & Thanks boss.......Easily to Understand...<br />Nice & Thanks boss....KISHORE.Unoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-30656955080437935282013-08-07T18:24:46.606+05:302013-08-07T18:24:46.606+05:30Hi,
If you want to add new column better create a...Hi,<br /><br />If you want to add new column better create a new table with linking with the existing table.(PK ,FK).<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-44870134746407872052013-08-07T14:38:27.920+05:302013-08-07T14:38:27.920+05:30And how he judged that ???And how he judged that ???Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-26324261553297044362013-08-07T13:29:10.894+05:302013-08-07T13:29:10.894+05:30Hi,
I have a requiremnt in my project..Below is t...Hi,<br /><br />I have a requiremnt in my project..Below is the requiremnt..<br /><br />we have a existing table which is having Huge million set of records and more than 200 columns.Also the performance of the table is high.<br />We need to add a new column in the existing table.But DBA is saying that if we add one more column ..The performance of the table will be very slow..<br /><br />Please help me how can go for it..<br /><br />Thank,<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-47047567274108185252013-08-05T12:31:34.987+05:302013-08-05T12:31:34.987+05:30Exploit Google to gain further knowledgeExploit Google to gain further knowledgeNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-43993835204728038032013-08-05T12:31:06.832+05:302013-08-05T12:31:06.832+05:30You can return an object or even ref-cursor from p...You can return an object or even ref-cursor from procedure to return multiple values. or simply you can have multiple out parameters<br />http://nimishgarg.blogspot.in/2012/11/view-results-of-refcursor-out-parameter.html<br />Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-65011947742019988122013-08-05T12:23:24.101+05:302013-08-05T12:23:24.101+05:30Hi,
1. What is the disadvantages of using BULK Co...Hi,<br /><br />1. What is the disadvantages of using BULK Collect in oracle..?<br /><br />2. Can a out parameter return Multiple values using a procedure..?<br /><br /><br />Thx<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-64235255317163090532013-07-19T16:32:22.821+05:302013-07-19T16:32:22.821+05:30excellent features...excellent features...Anonymousnoreply@blogger.com