Oracle has some questionable features. The command below generates the default value "0 " (with an extra space), not "0":
ALTER TABLE TEST1 MODIFY STATUS DEFAULT 0 NOT NULL
To generate without the extra space, it is necessary to join the value with the NOT NULL command:
ALTER TABLE TEST1...
I got a problem running DDL query to set a default value to a column:
Test case: Running in a SQL Window:
CREATE TABLE TEST1 (ID NUMBER(10), STATUS NUMBER(2))
ALTER TABLE TEST1 MODIFY STATUS DEFAULT 0
SELECT USER_TAB_COLS.DATA_DEFAULT
FROM USER_TAB_COLS
WHERE USER_TAB_COLS.TABLE_NAME...
I'm trying this solution, but I got the error "ORA-03001: unimplemented feature".
Steps to reproduce:
1. Create an empty table : create table test_clob (XCLOB clob)
2. Create an test insert dml: insert into test_clob values :XCLOB
3. Configure XCLOB variable as your response
4. Execute the...
How can I upload a large file to a LOB field? I'm trying upload a JSON file with 50Mb (not so large) into a CLOB column, but the large editor frozen trying to show the data. There is any way to upload a file without passing by Large Data Editor window?
I created a plugin with a configuratio window. I add the method SupportsStyles for add style support to this window. It works partially; the window is showed partially with the theme.
What I can do to fix it?
Is there a way to add a alias to the connection in "Fixed Users" list?
I connect to databases with complex names, like:
G7DBGT/myPass@XUWMP5
An alias for this would be very useful.