Hello ,
I have an oracle web application developed in 9i . How can i set up session timeout for the web application ? The client browser session should time out after 10 minutes of ina...
I am looking for a way to have my column header lengths always be the full name of the column and at the same time have my data always show only as long as it actually is and not aligning to t...
Hi - I have table 'a' with a NUMBER column (col1) that is of course always digits. The other table 'b' has the same column (col1) that is VARCHAR2 of 10 chars.
The b.col1 could be: '', '...
I need to get the time difference between 2 dates excluding weekends/bank holidays and only hours between 9am to 5pm (office hours)
my table
REF STARTDATE ENDDATE
...
Whenever I use chr(10) an additional character is getting inserted (May be chr(13)). How to get rid of this.
Please do not suggest to open the file using another programming language and use...
Hi
I want to get some information about Oracle developer such as;
Is Oracle developer 2000 and oracle developer 6i same/
can any one please provide some free tutorial online for oracle ...
I am migrating from sybase 12.5.1 to oracle 10.g using .CSV files. One particular column has huge clob data with lot of xml content etc.That column was not migrated properly.When i see .CSV f...
Hello There,
I need help on how to adjust the daylight saving time on TimeQPlus Biometric. My server DST was automatically updated itself. I tried to reboot my server and restarted arxserv...
Hello,
For a database called DB1 and a schema called SCOTT can you please give an example using Data Pump to:
1. Estimate how long an export will take (without actually running it)?
2. ...
Hi,
I have windows 2003 server with oracle 9i. When i saw the perfmon the avg disk quee length is showing 100% at that time the server performance is very slow. Can you give me a solution for...
We are at the beginning of a project. The Application Architect wants to use clobs to store XML Data. He has noted this data will not be read on a regular basis. I have been trying to do some...
I'm trying to develop a java stored procedure on Oracle 10.1.2 that makes use of many other libraries, (Axis, WSIF, custom libs), and I'm stuck on this permissions error. I've loaded all of th...
Hi,
I have copied the code below, I am trying to format the data so it is listed not spanning..
i.e.
test1
ping
test2
blah blah blah
NOT
test1 ping, test2 check file...
thx
Calculate in days hours minutes and seconds the TIME DIFFERENCE EXCLUDING WEEKENDS/BANK HOLIDAYS AND HRS BETWEEN 8 TO 6PM
Hi experts,
We have some reports where the queries are built dynamically.Sometimes if the filter criteria and the columns that needs to be displayed are huge then the query takes more time.So...
Hi,
When i am creating a tablespace with the size of 2G in Oracle 10g, its taking long time to create.
Even it is not completed in 20 mins.
Please advice what to do.
Regards,
