Is there a way in SQL to substring a field defined as LONG data type? Oracle.
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 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)...
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...
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...
Using Oracle 9i how to use like operator for strings like prasad's
Ex: select * from emp where ename like '%prasad's'
Export terminated successfully with warnings.
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number # with name "" too small
Despite the warning ab...
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 ...
Hello
I am quite new to Oracle so please bear with me. I have installed Oracle 9i on one of our test machines, which is a AIX box. I have created the oracle user and set the home directory ...
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...
folks,how in oracle can i export data into a csv format to a cretain path
lets say from database 'test' i want to export the table B(fields ID,text) into csv
the idea one the data is e...
Hi,
I want to load the data from clob datatype (more than 1 GB) to a text file using PL/SQl.
Can anyone suggest you the better approach to write the data to the file?
I need to export 2 tables from a an oracle 9i database.
location of file is:
tom = database
schema = tony
table names = act1, act2
what would i type in sqlplus to expot these tables?
what are the main advantages of ORACLE MERGE command.
Is it performance wise faster than Updates and Inserts
Oracle 9.2.0.1.0
Installed as "Personal" setup.
I have performed a typical install. My local user account is in the local ORA_DBA group.
On initial bootup, I can login to either OEM or...
Hi,
I am looking for an equivalent functions like IS_NUMERIC() from SQL Server.
In other words, I need to check if the character field condense number, character or date value.
Thanks.
I have the following query which i am trying to execute, but throws an error. I used 2 single quotes so that i can have 'Stop' in the database. Not sure what is causing the error is it the for...
What does wait event - library cache lock is ? how to resolve it ?
Hi All,
I'm wanting to create an Oracle function that OPENs a cursor passing a value.
I've done it before but I forgot the syntax...
The below gives errors:
PLS-00306: wrong number or ...
How can I replace text/string in CLOB or LONG field in ORACLE 9i
How to check the current DB / tables in oracle?
I would like to check the size of DB and tables in oracle?
I found a lot of sessions are hung. I killed the processes on AIX, but the Oracle sessions seemed to be running still. How do you kill sessions to make sure that none of hung processes/jobs ...
What's the difference between using
(a) CREATE INDEX and ALTER TABLE... ADD CONSTRAINT
and (b) CREATE UNIQUE INDEX ?
This questions is a follow-up from http:Q_22793798.html
Hi,
Can i use safely "ALTER TABLESPACE tablespace_name COALESCE" to free up unused space in any tablespace ( like ununsed extents). Is there any way to find if a tablespace needs to ...
I want a script which would list all the dependencies of a table
For example:
If I pass the name of the table, the script should list
1. The primary key
2. The dependant table(s) that use ...
