Top "Oracle10g" questions

How to disable oracle cache for performance tests

I'm trying to test the utility of a new summary table for my data. So I've created two procedures to …

oracle caching oracle10g performance

Oracle DBMS_LOB.INSTR and CONTAINS performance

Is there any performance difference between dbms_lob.instr and contains or am I doing something wrong? Here is my …

sql oracle oracle10g oracle-text

How to insert/update larger size of data in the Oracle tables?

I want to insert large size of data that character length is more than 10,000. I used CLOB data type to …

oracle oracle10g clob

Alter a nonunique index to a unique index

I have a few non-unique constraints that I want to alter into unique constraints ( business rules have changed since the …

oracle oracle10g constraints unique-constraint

Is it ok to use oracle 11g client with a 10g server?

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. …

oracle oracle10g oracle11g odp.net

Oracle SQL: select from table with nested table

I wonder how can i make select statement from table which have a typed column ? Type of this column is …

sql oracle oracle10g nested-table

Passing arguments to oracle stored procedure through scheduler job

I have a stored procedure which is being called from a dbms job. i.e. DBMS_SCHEDULER.RUN_JOB ('Procedure_…

stored-procedures plsql oracle10g scheduler dbms-scheduler

Create Schema in oracle 10g express edition

I have installed oracle 10g express edition and I did not find the option to create schema.. Is there a …

oracle10g oracle-xe

How to retain block position after a query -oracle forms

I have an oracle form with a data_block which displays 25 items. On the form I have a scrollbar and …

oracle forms oracle10g oracleforms

PL/SQL Logging - How to control?

I am looking to introduce a logging framework into our existing Oracle application to replace the use of DBMS_OUTPUT. …

oracle plsql oracle10g instrumentation