Top "Oracle10g" questions

Oracle is an RDBMS product.

PLSQL CASE WHEN CONDITION

I have two queries. Query 1. Below PL/SQL is not working. I want to store the output into varable test1 …

sql oracle plsql oracle10g ora-00923
How to return primary key from oracle merge query

I want to return the primary key from an oracle merge query. I'm using a single statement to insert if …

oracle merge oracle10g sequence sql-returning
TransactionScope - The underlying provider failed on EnlistTransaction. MSDTC being aborted

Our team have got a problem that manifests as: The underlying provider failed on EnlistTransaction; Cannot access a disposed object.…

c# entity-framework oracle10g transactionscope msdtc
maxTimeout value from Machine.Config is not picked up by C# winform app

I have been working on a winform app with Oracle 10g database which is using TransactionScope and wanted to modify …

c# transactions oracle10g transactionscope msdtc
PLSQL CLOBS into variables

I'm trying to save a CLOB into a variable to perform operations like extract and such. I have this code: …

oracle plsql oracle10g oracle11g plsqldeveloper
How to include the column USER_VIEWS.TEXT in a where clause

This seems like it should have been an easy thing to figure out but I am struggling to find any …

sql oracle oracle10g ora-00932 ora-00997
Should an Oracle database have more than one tablespace for data storage?

My team maintains an Oracle database that is approx. 200GB in size. All of the data (tables, indexes, etc) lives …

oracle oracle10g tablespace
materialized view creation is fast but refresh takes hours

I am using a materialized view, and I cant set it to fast refresh because some of the tables are …

oracle plsql oracle10g materialized-views
How to convert datetime HH:DD:SS AM/PM to HH:DD AM/PM

I have a gridview column, where I need to display time in format : 3/2/2012 1:22 PM but my Db saves as 3/2/2012 1:22:42 PM …

asp.net datetime oracle10g datetime-format to-char
Oracle MIN as analytic function - odd behavior with ORDER BY?

This particular case was distilled from an example where the programmer assumed that for two shipments into a tank car, …

sql sql-server oracle oracle10g analytic-functions