Top "Oracle10g" questions

Oracle is an RDBMS product.

what is the maximum value of MAXVALUE in sequence in oracle?

Could you tell me what is the maximum/minimum value of MAXVALUE in a sequence & what is the minimum/…

sql oracle oracle10g sequence
How to use Oracle global temporary table?

I am attempting to use an Oracle global temporary table without physically creating a table in the database. The following …

oracle plsql oracle11g oracle10g plsqldeveloper
Oracle 10G: ORA-06575: function in invalid state

I created a funcion like this CREATE OR REPLACE FUNCTION tax (p_sal IN NUMBER(4)) RETURN NUMBER AS v_tax …

function oracle10g
How to get available space in tablespace for a user (Oracle)

I'm working on a web application where I need to warn the user that they're running out of space in …

oracle10g tablespace
Update materialized view when urderlying tables change

I have a materialized view defined this way: CREATE MATERIALIZED VIEW M_FOO REFRESH COMPLETE ON COMMIT AS SELECT FOO_…

oracle oracle10g materialized-views
What is the difference between USER() and SYS_CONTEXT('USERENV','CURRENT_USER')?

In an Oracle Database, what are the differences between the following: user() sys_context('USERENV', 'CURRENT_USER') sys_context('USERENV', …

oracle plsql oracle10g oracle11g
ORA-12154: TNS:could not resolve the connect identifier specified

The issue started when i installed the server version with already existing client version of Oracle 10g. Background : The Oracle …

oracle oracle10g database-connection ora-12154
PL/SQL - Optional conditions in where-clause - without dynamic sql?

I have a query where not all conditions are necessary. Here's an example of what it looks like when all …

oracle plsql oracle10g dynamic-sql
How to reconfigure Oracle 10g xe on Linux

I have installed Oracle 10g xe from a deb file on linux, and then started to configure it using this …

linux oracle oracle10g
Copying data between Oracle schemas using SQL

I'm trying to copy data from one Oracle schema (CORE_DATA) into another (MY_DATA) using an INSERT INTO (...) SQL …

sql oracle insert oracle10g bulkinsert