Top "Oracle9i" questions

How can you tell which columns are unused in ALL_TAB_COLS?

When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as …

oracle oracle9i data-dictionary

Trying to make a job to be executed after each 1 minute,but its not working?

I have made this job,that should be executed in an interval of 1 minute,but it's not working. When I …

oracle plsql oracle9i dbms-job

the best way to track data changes in oracle

as the title i am talking about, what's the best way to track data changes in oracle? i just want …

oracle triggers oracle9i materialized-views cdc

Return Message of Error code in Oracle Stored Proc

The below procedure (in Oracle 11g release 1) accepts a sql as a parameter & returns its return code. Returns 0 if …

oracle oracle10g oracle11g oracle9i

ORA-00920: invalid relational operator

This SQL query seems to be hitting ORA 00920. select username, count(*) from host where created_dt between to_date('2012…

sql oracle9i

Calling oracle stored procedure using spring stored procedure

I have been trying to get a piece of code that uses spring and oracle stored procedure with parameters but …

java spring stored-procedures oracle9i java-ee-5

What query should I write to calculate the cumulative salary of employees from the salary table

A salary table is given and we need to write a single query which prints the cumulative salary of employees. …

sql oracle oracle9i

Upgrading to Oracle JDBC thin driver results in SQLException: Unexpected exception while enlisting XAConnection

In Upgrading to Oracle JDBC thin driver results in SQLException: Unexpected exception while enlisting XAConnection (WebLogic Server 10.0, oracle version ) we …

java jdbc oracle9i weblogic-10.x

DBMS_OUTPUT.NEW_LINE and DBMS_OUTPUT.NEW_LINE() difference?

What is the difference between these two statements? dbms_output.new_line(); // with no parameters. dbms_output.new_line; // with …

oracle plsql oracle9i

Specify IBatis query timeout

There is a way to specify IBatis query timeout using oracle jdbc and Java? Thanks

java jdbc ibatis oracle9i