Hi Guys we have begun having a problem with many of our computers at work the last few days. When we attempt to connect to Oracle 9i forms (using JInitiator 1.2.23.1 (iirc)) the following occu...
Hi,
I execute sqlplus myuser/mypassword@myhost @c:\temp\batchtest.sql
In the batchtest.sql, I have this :
spool C:\Temp\test1.txt
@C:\Temp\testphm.sql
spool off
exit
In the t...
Hi folks,
I have a table already created on which I want to add a partition by range on a date column. I checked for for the syntax on the Net and most of them:
1. Either explain the syn...
folks
in sql i used the right or left function
i.e select right(wonum,3) from workorder
how does it work in oracle?
Hi experts,
I have PL/SQL procedure, which fetchs row and concatenate rows into a column with a delimiter and insert on to table. This process is done row by row.
For example,
source tabl...
I have two arrays arrA,arrB with strings. Is there a efficient way to find out if any one element of arrA is
member of arrB using Javascript methods(for all browsers)
Hi All,
Why cant I use the column alias on the having clause or in the where clause. Am I missing anything or Oracle doesnt support aliases other than order by clause?
If I want to re-...
Oracle SQL.
1. What is the function to add a day to a date field in a sql statement?
Hello, I have an oracle instance named CORPOR.
I need to get a listing of all schemas, the tables underneath it and their columns as a listing. Can you please help me generate a SQL for this?...
Hi,
I select rows from a table in Oracle. In the table there is a date field.
I call that field (in the select sentence like that :
string s = @"select DISTINCT USERID, USERNAME, TO_CHAR...
Hi, I'm a newbie to vbscript and oracle. What I'm trying to achieve is to use vbscript to connect to Oracle database to pull some data out. I've installed the oracle client in my laptop. Below...
Can someone please tell me what I am missing. I have everything in place, datafiles, controlfiles ,redo logs why can't I open the database????
I:\oracle\xr3\oraarch>sqlplus "/as sysdba"
...
I have Timestamp field in my Oracle table. I need to get difference between SYSDATE and Timestamp field in exact number of seconds. Any idea how it can be achieved.
In order to defragment Oracle memory, I have to schedule - every 1-2 hours - the following Oracle instruction:
ALTER SYSTEM FLUSH SHARED_POOL;
In YOUR opinion, what is the best way, and why?...
Hi,
If I have created a package 'A' and I need to grant the following permissions on 'A' to a role 'R' how do I write this in SQL, the persmissions I need are..
1) Drop both package body...
Hello,
I have a table whose date fields are all declared as NUMBER. For example, the value 14076 is supposed to represent 16-Jul-2008. I'm not sure how this number was created - whether it wa...
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
System: Microsoft Windows Serv...
Hi, just checking whether there's such thing as cascade delete in Oracle? If yes, how do we configure or add the cascade delete? Can it be done through the Oracle enterprise manager, or we mus...
I have got during
select * from Table;
ORA-29275 partial multibyte character and no result.
Message:
ORA-29275 partial multibyte character
Cause: The requested read operation could not ...
Is there an oracle function that concatenates row values? Say I have the following table:
UserColor:
Username Color
----------------------------------
Jim Red
Jim ...
I am running a medium sized databse (75 Gig) on a Unix server with Oracle 9i
What is the difference between Analyze Table and DBMS_STATS ?
I understand that Analyze table is a depricated f...
Using Oracle 9i how to use like operator for strings like prasad's
Ex: select * from emp where ename like '%prasad's'
dear experts,
I do have the oracle -export dump of 1000+ tables. I would like exclude the just one table while import .
How to specify the parameters for the import in such cases.
Fo...
I run the following query to find the sid who has a lock and the waiting sid but the query runs very slow in our test environment even when there are no records in v$lock view. Any reason why...
how do i copy a schema from one user to another
