I’d like to find out the correspondence between XML Schema totalDigits/fractionDigits and SQL numeric precision/scale. 1) Assume we have the following simple type: How would I represent it in SQL? Let’s assume HSQL dialect (it does not matter much). I’m interested in the most restrictive SQL…
Tag: ddl
Upgrading a varchar column to enum type in postgresql
We have a varchar column in a table, that we need to upgrade to enum type. All the values in the varchar column are valid values in the enumeration. There is no null values in the varchar column. …
SQL Column definition : default value and not null redundant?
I’ve seen many times the following syntax which defines a column in a create/alter DDL statement: The question is: since a default value is specified, is it necessary to also specify that the column should not accept NULLs ? In other words, doesn’t DEFAULT render NOT NULL redundant ? Answer DEFAUL…
Oracle: DBMS_UTILITY.EXEC_DDL_STATEMENT vs EXECUTE IMMEDIATE
Which are the differences between DBMS_UTILITY.EXEC_DDL_STATEMENT and EXECUTE IMMEDIATE? Answer Fundamentally they do the same thing, which is to provide a mechanism to execute DDL statements in PL/SQL, which isn’t supported natively. If memory serves me well, the EXEC_DDL_STATEMENT was available in the…