Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.
0
votes
1answer
7 views
Regex_like - Passing comparison string as a query - Oracle
I have the following table :
SrNo Name
------------
1 TOM
2 JOHN
3 HENRY
Running the following query:
SELECT * FROM MYTABLE WHERE regexp_LIKE (NAME, '^(TO|HEN)')
gives the ...
0
votes
0answers
9 views
Unusual table table1 is mutating, trigger/function may not see it error in Oracle
I have a trigger like this: (Basically on update of a column in table1, I update a column in table 2)
CREATE OR REPLACE TRIGGER AAA AFTER UPDATE
ON TABLE_1 REFERENCING NEW AS NEWROW OLD AS ...
0
votes
0answers
8 views
Oracle date column returns results in order but need to see milliseconds
As Date uses a precision only upto second and we need to use timestamp to have more precision (upto milliseconds).
I run a query and sort in descending order of the create_date field which returns ...
0
votes
0answers
7 views
Installing Oracle 11g on redhat server without Xming
Is there any way that i can install oracle 11g on a remote server without using Xming ?
0
votes
0answers
12 views
Create oracle workspace with sqlplus in installshield?
I am in the process of creating an installer that automates the oracle installation process using InstallShield; however, I am running into problems.
Basically, what I need to know is if there is a ...
0
votes
1answer
20 views
Check If VARRAY Type Is Empty
I have a database table with a column called 'node_names' that is a user defined VARRAY type. There are records in my database table that have populated the 'node_names' column with an empty VARRAY.
...
0
votes
0answers
8 views
In oracle Application how can i directly print the completed request report
In oracle Application how can i directly print the completed request report.
i.e when the request is completed, a print of the output should be automatically printed by the default printer set on that ...
0
votes
1answer
25 views
Oracle calculate 2 date columns to a new one for each row
in our Application we have two columns at the moment. 1 column with the datetime of an event and 1 column with the datetime how much earlier the alarm should go off. Now we have a new one and thats ...
0
votes
1answer
60 views
Same code but different result
i have a strange problem, there is two same code:
The first one :
$arraysch= @()
$hash = @{}
Add-Type -Path ...
2
votes
1answer
43 views
Change separator of WM_CONCAT function of Oracle 11gR2
Normally, WM_CONCAT is an aggregate function that return values from table separated by comma like here.
Suppose I have a table foo like this:
col_id | col_text
111 | This
111 | ...
0
votes
0answers
9 views
How to manage concurrency in an ASP.NET MVC 4 application having Oracle 11G as database?
My MVC 4 application is having Oracle 11G database as its backend. How can I handle concurrency here? I am quite new to Oracle. I know, in SQL Server, we can use timestamp column, but not sure how can ...
0
votes
2answers
19 views
How to upgrade java version in Oracle 11g 11.2.0.1 [closed]
The java version of my oracle database is 1.5.0_10.
How do I upgrade it to java 1.7.0_10
Thanks
0
votes
0answers
16 views
Unable to add reference
I am unable to add reference of oracle.dataaccess.dll in visual studio 2003.
i am using oracle 11g and windows 8 (64 bit).
Following error appears: This is not a valid assembly or COM component. ...
0
votes
1answer
11 views
ORA-22912 specified column or attribute is not a nested table type /oracle creating nested table
I was working with OODB and tried to make a nested table using two tables. I am posting code here
create type BranchType as object(
address AddrType,
phone1 integer,
phone2 integer );
create table ...
0
votes
0answers
21 views
ORA-31608: Specified object of type CONSTRAINT not found
i am trying ti export DDL and data for an oracle database using Oracle SQL Developer, but i am getting the following errors in log:
Error while registering Oracle JDBC Diagnosability MBean.
...
