Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.
I have existing table which has 10 years of data (I have taken dump). I would like to Range partition the …
oracle create-table alter-table partitionIs it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus: sqlplus …
oracle sqlplus sql-loader tnsI have an Oracle linked server in SQL Server 2008 R2. I need to execute Oracle stored procedures (with output parameter …
sql sql-server oracle stored-procedures linked-serverSELECT COALESCE ( (to_timestamp( '2014-09-22 16:00:00','yyyy/mm/dd HH24:MI:SS') - ('2014-09-22 09:00:00' ,'yyyy/…
oracle timestamp date-arithmeticI have a table and there is a partition on it. There are 16 hash partition which is starting from SUBSCRIBER_01 .. …
database oracle plsql oracle11g database-partitioningI'm trying to split a string using a string as a delimiter, in an Oracle store procedure. I can use …
regex oracle regexp-substrThis question is asked (and answered) just to share some knowledge with the SO Community. I have recently came up …
oracle weblogic weblogic-10.x jdeveloperThe data from the infile is in the format MM/DD/YYYY how do I tell the control file to …
sql oracle sql-loaderSurely this should be the same as a termination of a session and cause a rollback? It seems to me …
oracle sqlplusI'd be more than interesting for me to understand which technique is being used here to persist sensible data since …
java oracle oracle-sqldeveloper jdeveloper