Oracle Server is a relational DBMS (Database Management System) created by Oracle Corporation. Do NOT use this tag for other DBMS servers owned by Oracle (for instance MySQL, TimesTen and Berkeley DB).
0
votes
0answers
7 views
How to view the foreign keys relationships on a DB table in Oracle
I know that in order to view the uniqueness of a table you use something like this
set serveroutput on;
BEGIN
<DB name>.show_uniqueness('BILL_BASE.<Table name>');
END;
and this ...
-1
votes
0answers
7 views
bulk collect …for all usage
I want to understand the usage and need for bulk collect forall statements.
An example mentioned here
In most examples in different web pages; authors first fetch data from a table by using bulk ...
0
votes
0answers
6 views
Error while starting Oracle Weblogic: Assertion failed: ia_addressID, file Net.c
I installed oracle weblogic 10.3 on Sun Sparc with jrockit 1.6.045. When i start with command ./startWebLogic.sh, i am facing following error
Jun 13, 2013 3:32:50 PM PKT> <Notice> ...
0
votes
0answers
20 views
ODAC: nvarchar column value is truncated
I am using ODAC library version 8.6.12 to connect to oracle with Delphi 6, I have a nvarchar(32) column as you can see it has a maximum of 32 characters and lets say that I always use 32 character ...
0
votes
0answers
14 views
Oracle - Query which Privileges are granted which Roles on which Objects
I need to query an Oracle database and get back which privileges are granted which roles and on which objects. Because I am going to either revoke or grant privileges to roles on objects according to ...
0
votes
3answers
27 views
Oracle 11g: only return a value if row is first or last in group
I'm trying to create a report from an Oracle query. The data is like this:
GROUP_ID | COUNT_1 | COUNT_2
1 | 100 | 123
1 | 101 | 123
1 | 283 | 342
1 | ...
-1
votes
2answers
49 views
Need to delete duplicate records from a table with 30 columns
I need to delete the exact duplicate records from a table with 30 columns.
My data would look something as attached.Advance Thanks!!
0
votes
0answers
29 views
How write the ignore dupkey command in unix?
I know that in oracle the is a way to write to ignore the dupkey, something like
/*+ ignore_row_on_dupkey_index(tab, index_tab) */
Is there a way to do the same thing but with unix commands? I ...
1
vote
0answers
51 views
Finding count of similar objects used by two different rows
This question is in continuation of
How to find the child project of a parent project which is passed in the 'WHERE' clause and also, to find the duplicate objects
I have prepared a query ...
0
votes
0answers
17 views
Oracle ODB.NET, Visual Studio 2012 Error
I created an Oracle DB. But when i tried to connect it with my Visual Studio 2012, it gave me the same errors all the time. What can i do about that situation. I looked up all the net.
Thanks for ...
0
votes
1answer
20 views
Oracle PHP update no response
I got a very weird problem with oracle today.
I setup a new server with xampp for developing, i activated mssql and oracle and everything was just fine until i tried to execute an update statement.
...
2
votes
0answers
53 views
ORA-01001 invalid cursor
I have an "ORA-01001 invalid cursor" issue I am not able to solve.
In our production environment, we have three application server and it's pointing the single Database(Oracle 10g).
I am receiving ...
-2
votes
1answer
28 views
Access path from indexes
I have here a litle exercise about Indexen but I am not sure how to make it.
What is the access path for:
SELECT instituteID, totalPrice
FROM Purchases_XX
WHERE totalPrice > 59 AND spDateID = 2
...
0
votes
1answer
30 views
constraint on all numerical tables
I need to put a constraint on all numerical columns, this is what I tried:
Everything has to be possitive
ALTER TABLE * ADD CONSTRAINT Checknumbers CHECK ( > 0 )
This isn't working but I can't ...
0
votes
3answers
43 views
How to insert Hex data into the oracle table?
I have the following table:
create table o_newstdata1 (
field1 raw(8)
);
the following input.data file:
0x12345678
0x1234
0x12
how can I insert such a data into my o_newstdata1 table?
I've ...
