Use the spool: spool myoutputfile.txt select * from users; spool off; Note that this will create myoutputfile.txt in the directory from which you ran SQL*Plus. If you need to run this from a SQL file (e.g., “tmp.sql”) when SQLPlus starts up and output to a file named “output.txt”: tmp.sql: select * from users; Command: sqlplus … Read more
Section 3 of RFC4122 provides the formal definition of UUID string representations. It’s 36 characters (32 hex digits + 4 dashes). Sounds like you need to figure out where the invalid 60-char IDs are coming from and decide 1) if you want to accept them, and 2) what the max length of those IDs might … Read more
From Wikipedia (which has great and detailed examples for this): A non-repeatable read occurs, when during the course of a transaction, a row is retrieved twice and the values within the row differ between reads. and A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection … Read more
Performance depends on the Oracle version you use. Locks are generated anyway. If version <= Oracle 11.1 then #1 does the same as #2. It is slow anyway. Beginning with Oracle 11.2, Oracle introduced a great optimization for the first statement (one command doing it all). You don’t need to change the command – Oracle … Read more
In earlier times you were always forced to use DBMS_LOB package. Then in Oracle 10g a feature called “SQL semantics for LOB” was introduced and now you can use the simplified syntax. In CREATETEMPORARY you can specify the duration of the LOB in SQL semantic you cannot. In your case the LOB is freed in … Read more
EDIT: The fully managed ODP.NET is now available in production. It is very small (less than 10MB) and is not dependent on other files. You can obtain it here: http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html Original answer: One way to easily ensure that the required Oracle client side software (including ODP.NET) is always available on the deployment machine is to … Read more
This seems to be Oracle’s official repository for docker – https://github.com/oracle/docker-images More details here – https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers
This doesn’t really answer the question, but it seems to be a parser bug (or ‘feature’) rather than a language requirement. According to My Oracle Support, this seems to have been raised as bug 14196463 but closed with no resolution. It’s also mentioned in community thread 3561546. You need a MOS account, or at least … Read more
You could try the INTERVAL DAY TO SECOND data type but it won’t save you any disk space … it is very suitable for this purpose though. create table t1 (time_of_day interval day (0) to second(0)); insert into t1 values (TO_DSINTERVAL(‘0 23:59:59’)); select date ‘2009-05-13’+time_of_day from t1; 11 bytes though.
My Direction and Requirements Entity should store XML as a string (java.lang.String) Database should persist XML in an XDB.XMLType column Allows indexing and more efficient xpath/ExtractValue/xquery type queries Consolidate a dozen or so partial solutions I found over the last week Working Environment Oracle 11g r2 x64 Hibernate 4.1.x Java 1.7.x x64 Windows 7 Pro … Read more