oracle9i Questions
21
Solved
I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Usern...
7
Solved
I'd like to create an in-memory array variable that can be used in my PL/SQL code. I can't find any collections in Oracle PL/SQL that uses pure memory, they all seem to be associated with tables. I...
5
Solved
I have the following string in an Oracle 9i database:
A,B,C,
I need to replace all instances of ',' when it is the last item in the string. I have come up with the following statement but it dele...
Peres asked 18/9, 2013 at 17:17
20
Solved
I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ?
Can anyone tell me a perfect solution to solve login problem...
4
Solved
I have a script that I use in SQL Server but I need to convert it to an Oracle format. Can anyone help?
UPDATE PERSONS P SET
P.JOBTITLE=TE.JOBTITLE,
P.LAST_NAME=TE.LAST_NAME,
P.FIRST_NAME=TE....
Merrillmerrily asked 8/5, 2013 at 14:17
14
I want to use oracle syntax to select only 1 row from table DUAL. For example, I want to execute this query:
SELECT user
FROM DUAL
...and it'd have, like, 40 records. But I need only one recor...
6
Solved
When I try connecting to my database, I get the following error.
ORA-00257:archiver error. Connect internal only until freed.
Till yesterday, the database was pretty functional.
Any workaroun...
7
Solved
I have a sequence used to seed my (Integer based) primary keys in an oracle table.
It appears this sequence has not always been used to insert new values into the table. How do I get the sequence ...
3
Solved
I'm comparing three Oracle schemas.
I want to get a list of all the functions and procedures used in each database. Is this possible via a query? (preferably including a flag as to whether they co...
7
Solved
Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?
Symbolism asked 17/9, 2008 at 14:41
4
Solved
How do I get a substring from this example value:
john.abc_1234
I want it to return john.abc.So basically we need to remove all the information after _.
More examples: 1234_abc
9
Solved
I'm looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn't seem to be supported in Oracle.
INSERT INTO TMP_DIM_EXCH_RT
(EXCH_WH_KE...
Olvan asked 2/9, 2008 at 13:56
4
Solved
SELECT YEAR, period, round((1- sum(rej_qty) / sum(recd_qty))*100, 0)
FROM TAB_A
WHERE sid = '200'
AND sdid IN ('4750')
AND
(
(
YEAR ='2011'
AND period IN('01_JAN')
)
OR
(
YEAR = '2010'
...
Adelric asked 17/2, 2011 at 10:38
3
Solved
guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly.
declare
type a is table of number;
type b is table of a;
arr b := b(a(1, 2), a(3, 4));
begin
for i in...
Detonator asked 14/9, 2010 at 8:15
11
Solved
I have a table:
abc_test with columns n_num, k_str.
This query doesnt work:
select distinct(n_num) from abc_test order by(k_str)
But this one works:
select n_num from abc_test order by(k_st...
Grande asked 18/1, 2012 at 6:1
8
Solved
I have come across an Oracle problem for which I have so far been unable to find the cause.
The query below works in Oracle SQL developer, but when running in .NET it throws:
ORA-01008: not all ...
Ciri asked 20/9, 2011 at 23:36
5
Solved
Is there any way I could filter the text column on oracle's all_views table?
For example:
SELECT *
FROM ALL_VIEWS
WHERE UPPER(TEXT) LIKE '%FOO%';
Exception:
ORA-00932: inconsistent datatyp...
5
Solved
When I have a sql statement like select * from table1, it works great, but as soon as I put it into a function, I get:
ORA-00942: table or view does not exist
How to solve this?
3
Solved
I want to create a batch file which will open the SQLPLUS [CLI] and will execute some stored sql file and will also store the output to text file.
So I've created this batch file [which does not w...
Insinuate asked 7/5, 2013 at 5:49
6
Solved
I am trying to write in a file stored in c:\ drive named vin1.txt
and getting this error .Please suggest!
> ERROR at line 1: ORA-29280: invalid
> directory path ORA-06512: at
> "SYS.UTL_F...
1
Solved
I'm attempting to create a query to transpose rows into columns using the PIVOT function.
This is the contact table I want to transpose into rows:
PARTYID CONTACTTEXT CONTACTTYPECD
---------- --...
2
Solved
I need to update a row with a formula based on the largest value of two DATETIME columns. I would normally do this:
GREATEST(date_one, date_two)
However, both columns are allowed to be NULL. I n...
1
Solved
I just found what I think is somewhat unexpected behavior in PLSQL vs SQL in Oracle.
If I run this query on SQLDeveloper I get 5 results:
select level lvl from dual connect by level <=5;
But...
9
Solved
We have a table which is of the form:
ID,Value1,Value2,Value3
1,2,3,4
We need to transform this into.
ID,Name,Value
1,'Value1',2
1,'Value2',3
1,'Value3',4
Is there a clever way of doing this ...
2
Solved
I have a table containing full body of water names in one column. ie:
Golden Lake
Blue Water Lake
Muskoka River
Sandy Bay
I would like to select the water name, but not the type of water [lake,...
Xylia asked 7/6, 2013 at 12:36
1 Next >
© 2022 - 2024 — McMap. All rights reserved.