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...
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 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 all,
Im getting this "ORA-00942: Table or view does not exist" even though i have this table in my database. The following is the situation where im getting this. I have a table b...
Need to insert more than 4000 of data into an Oracle Clob column. I notice the size on the clob column is 4000 by default. I'm using Oracle 9i.
We are using .net/c#. How do we insert more ...
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...
Oracle SQL.
1. What is the function to add a day to a date field in a sql statement?
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...
HI,
These are my TNS files I have two database on the testserv
and I face the error when I am try to connect with the database
there is no listener -- ora-12541:tns:no listener
I a...
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...
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-...
Hi Guys -
I need to find if a substring exists in any of the rows of a table.
say my table has a column media_url which has the following values
pub/media/100/na_10.jpg
pub/media/1...
Using Oracle 9i how to use like operator for strings like prasad's
Ex: select * from emp where ename like '%prasad's'
Oracle 9i database.
I am trying to recliam space from defrag tables. so I use the command "move" the large tables, then rebuild its indexes. however, for some reason i notice the size increa...
Hi,
I am trying to export data from Oracle 9i enterprise edition using (exp)
server\BIN> exp usr/pwd file=emp.dmp full=yes
then I copied emp.dmp file to Oracle 10g express (....\server\BIN)...
Can anyone explain why I am unable to see the drop down list for TNS Server name. i have a TNSNames.ora file set up in the admin folder of my Oracle 9 folders. When I try to create an ODBC C...
Im developing a C# windows forms application with an Oracle 9i database.
I get the following error when i try to connect to an oracle database from Visual Studio.NET.. However when i run t...
Hi, all! I am having an issue between Oracle 8i and 9i databases. We have always used varchar2 in Oracle 8i. Now, in 9i, a vendor has updated the database and changed all varchar2 fields to...
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...
Is there an oracle function that concatenates row values? Say I have the following table:
UserColor:
Username Color
----------------------------------
Jim Red
Jim ...
Is there a way in SQL to substring a field defined as LONG data type? Oracle.
I posted this query earlier concerning sql server - then realised I also need it for Oracle
I need to manipulate numbers in a string - for example my table would be as follows:
col_1
V...
Hi Folks,
I need to load data from Oracle tables into a flat file which is a fixed positional flat file i.e each column should be in a particular position and it should be fixed. My OS is W...
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...
