how to change a String to Clob,and how to change Clob
to String by java?
This is a rather fun error. I have done some research and this is what I know so far:
1) The way to get this error is to start a 'long running' query and then have another user (or applicat...
Input:
3 Servers, all with Oracle 9.2
* PROD --- live production server
* STANDBY --- standby database, updated every night by applying the logs, the rest of the day it is open a...
folks
how do i convert the datepart function in sql server to oracle
i.e
SELECT datepart(year, SYSDATE)
, datepart(month,SYSDATE)
all help will do
r
Is it possible to use both the Select clause and returning into in the same insert statement?
For example:
Insert into table_a
(value1, value2)
Select value1, value2
From table_b
Ret...
Hi ,I am getting the following error,Increased the no. of processes too but of no use still getting the same error,so is there anything i need to check for.
ORA-12516: TNS:listener could no...
1) We have a Oracle 10g r1 database server on windows 2000 server.
2) This is a existing parameter and its value:
NLS_CHARACTERSET WE8MSWIN1252
3) We need to change as fol...
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing V500's objects into V500
. . importing table...
Hi all,
I am trying to update a column in a table with data from another table. The SQL I am using is:
update TABLE1 a
set a.col1 = (Select b.COL2 from TABLE2 b
where a.COL3 = b.COL3...
I have got following Error When I executed a Query
ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [xtycsr3], [], [], [], [], [], [], []
...
I know sqlserver but I am new to oracle
1) I would like to know how to create a simple stored procedure which brings all the values from a table.
2)To alter the first procedure and to accept...
Difference between order by and group by having ?
suppose i have students table which has id number ,sname varchar2(20),marks1number ,marks2 number,marks3 number,age number.
i would like...
We have started experiencing this error in the last few weeks and are trying to identify the cause. We opened a ticket with Oracle and one with HP (SAN) I from the web servers and found thi...
Can anyone recommend descriptive tutorial online on how to write stored procedures in oracle, with lots of examples.
Thanks for help !!!
HI,
I created one new Oracle user TOM
I've one package MY_PACK (OWNER IS SAM) that has 5 new tables in it (TOM HAVEN'T GRANT ON THESE 5 NEW TABLES)
with user SAM I run:
grant exec...
Hi Experts.
I have a problem with a 9i database on win2k svr , I cant start the listener for OEM
LSNRCTL> start oem
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Versi...
All,
I have the below situation
Table : ABC
Owner : JOHN
Another Owner : DAVE
Dave needs to Truncate ABC and Insert rows
what does JOHN grant to DAVE in terms o Ora...
Hello,
I have a control file test.ctl like this:
LOAD DATA
INSERT NTO TABLE TEST
FIELDS TERMINATED BY '|'
(
COL1,
COL2,
COL3 "1234"
)
and I load the data by
sqloader contr...
Hi,
I'm searching in oracle 9.2i for a string with <>'' but I don't get the exprected result. e.g
Select * from mt_filearchivev WHERE "Value"<>'';
but I get no row, even there is a row with...
Dear oracle experts
Is there a way to delet all database tables in oracle
Hi Experts,
I have two processes running and both want to update the same record. The First process sends a packet to the second one containing the update metarial for the record the second p...
I get this error when i try to insert the below statement into my database. It is happening at '17-Apr-02 03:26:45 PM'
ERROR MSG:ORA-01830: date format picture ends before converting entire...
Hi,
I am having a strange problem with an ORA-06502 error I am getting and don't understand why. I would expect this error to be quite easy to fix, it would suggest that a variable is not ...
I am very new to oracle and just installed 10g , I dont remember being asked to create a user id but id do recall settng a password , what would be the default user id to log into the database?
Maybe it's not a difficult question:
How to perform a full export and then after make a full import of an Oracle 9i? I need to do it with system user.
Make a dmp file of all schemas of the d...
