I’ve always wondered why the VARCHAR2 datatype was limited to so few characters. For most attributes, you do not need more than 2,000 bytes. I remember when Oracle upped the limit from 2,000 bytes to 4,000. But SQL Server 2008R2 lets you use 8,000. We are talking about character data and the 2,000 or 4,000 …
July 31, 2013 archive
Jul 31
12c Autopopulating Column with Sequence Value
In yesterday’s blog post, I wrote about creating a table with an IDENTITY value. But the Oracle 12c new feature that I like better is allowing a sequence to be the number generator for the default value of a column. To see what I mean, look at this example: SQL> create sequence test_seq; Sequence created. …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
