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...
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 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
...
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: '', '...
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 ...
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...
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...
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...
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...
Calculate in days hours minutes and seconds the TIME DIFFERENCE EXCLUDING WEEKENDS/BANK HOLIDAYS AND HRS BETWEEN 8 TO 6PM
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...
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...
I was advised to use sql loader to load data to data base and I need to know how to get data into the file from which it will be inserted. I need help step by step. My program in oracle runs a...
