Top "Oracle10g" questions

Oracle is an RDBMS product.

How to get the numeric difference between DBTIMEZONE and SESSIONTIMEZONE?

Is there in Oracle a smooth way to get the numeric difference between SESSIONTIMEZONE and DBTIMEZONE at the current moment (…

Read More
oracle oracle11g oracle10g timezone timezone-offset
Updating a column in one table through a column in another table

I have 2 tables 'A' and 'B'. Both have a common column 'name' and linked with each other by a column …

Read More
sql oracle oracle10g sql-update tablecolumn
how to find length of a Long Column in a table

I have a LONG column named FileSize in a table called Files. To achieve the objective, I did the following : …

Read More
oracle plsql oracle10g ora-00905
How can you see what transaction isolation level an arbitrary oracle session is using

I am trying to find out what isolation level a particular session (not my own) has on an oracle server. …

Read More
oracle transactions oracle10g isolation-level
ORA-00904 INVALID IDENTIFIER with Inner Join

I'm trying to do an inner join between 3 tables in an ERD I created. I've successfully built 3 - 3 layer sub-queries …

Read More
sql oracle10g inner-join ora-00904
PLS-00103 Error at end of function

Receiving the following error relating to a function: 'ERROR at line 20: PLS-00103: Encountered the symbol "end-of-file" when expecting one of …

Read More
plsql oracle10g oracle-xe pls-00103
List only Oracle Temp Table Space

Is there way to list only temp tablespaces in Oracle? I found following query which is listing all the tablespaces, …

Read More
database oracle oracle11g oracle10g tablespace
string aggregation in Oracle 10g

How to aggregate string( concatenate) with Oracle 10g SQL?

Read More
sql string oracle10g string-aggregation
java.lang.AbstractMethodError: oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V

I'm getting the following exception when trying to insert the contents of a CKEditor (for CMS - Contents Management System) …

Read More
spring hibernate oracle10g clob
How to schedule a work to run at particular time using dbms_scheduler

Im not clear about this, here in DBMS_SCHEDULER we have CREATE_PROGRAM CREATE_JOB CREATE_SCHEDULE etc., after reading …

Read More
oracle oracle10g oracle11g advanced-queuing dbms-scheduler