I have an Oracle table with a CLOB field that contains XML-Data. I would like query this table and make use of Oracles xmltype function and extract the value of a specific XML-Tag.
Oracle re...
Hello Experts,
I have successfully installed Oracle 11g and created two sids.
However,
I have no idea what my GLOBAL_DBNAME is or where to find it.
Does anyone know how?
thx,
I am supplying a parameter value from the front end.
select * from emp
where decode([parameter],NULL,'~~',
empno) = decode([parameter],NULL,'~~...
hello,
i try to update xmltype column with SchemaBased xsd, the first few attempt is alright;
from the code snippet i attached, it returned me with these errors. i looked into the trace fi...
How Can I check if an oracle database is in standby mode?
and if it is, how to put it out of standby mode ?
Thank you!!
Experts,
How do I create a silent installaiton using the answer file (enterprise.rsp) for Oracle 11g on Windows Server 2003?
Thanks, MIssymadi
Hello,
I have strange problem.
I have one database server with Oracle 11 which in fact is Virtual machine on MS Virtual Server.
Database is working normally but occasionally users reports...
I have a new Vista Home Premium Laptop and I'm trying to install Oracle Database (11g) on so I can learn to use it. I've installed the Loopback adapter, so I can continue to use DHCP, but I'm...
I have a mysql table with columns id, tx, tx_type, s_id, date
in the above table, tx contains amount values, tx_type contains either 0 or 1.
Now i want a resultset in two columns with
...
hi experts,
i have this nested xml
<sponsornode code="johnny" level="0" legno="1">
<sponsornode code="max" level="1" legno="1">
<sponsornode code="chris" level="2" legn...
We have a financial apps that our management wants to be on high availability.
We had crafted out a failover solution based on Windows 2008 Server Enterprise failover cluster with 2 dedica...
If we looking for sys tem that back up oracle 11 g run on windows 2003 every day
Do we need a computer to connect to network and set up to back up every day Please suggest
Hello experts. We are looking for a way to backup the DDL or our oracle databases. We really only want the Materialized views, triggers, packages, procedures, and functions.
Does anyone have...
I need to do DELETE more than 1,000,000 records from a table, however, how can I make the database directly delete that records without allowing Rollback.
Thanks!
I have three databases DB2, SQL Server and Oracle. I am trying to create the databases with similiar DDL of course I know it cannot exactly match. I am getting an error when I try to build a...
I have a table that stores values with a date range validity.
Given a start and ending date, I would like to query the table above and it should return rows with values and the corresponding...
Hi i have a user whenever he uses IE to browse the internet he is not getting any iexplore.exe messages. However when he tries to use IE to go to a Oracle sms application server forms page tha...
We were planning to implement high availablility for our Finance application, initially we thought of using Windows 2008 Enterprise cluster for Oracle 11g, but it seems this solution is not te...
Hi,
I have a table in Oracle 11g that holds an XML document (as XMLType) and another column tha contains a GUID that services as the primary key. I have method that accepts a GUID and...
Whats is oracle retek. Do you have any good documentations for oracle retek.
I have loaded oracle 11g stored procedures scripts that were modified. How do I retrieve the code from the compiled scripts so I can modify them again.
I am not that familiar with oracle...
We had an energy shortage and all servers were suddenly turned off. (yeh, we need to get those no-breaks sorted out...)
Something went wrong in the db server (Windows Server 2003 - Oracle 11g...
I have multiple user schemas and one Master schema. I intend to place common packages in the Master Schema and grant the rights so that the users can utilize them. Make maintenance easier.
...
Hi all,
We have a 2 node Oracle 11g RAC environment configured on RHEL 5 in our local environment. Yesterday the system admin moved the servers to another floor and now the IPs of the serv...
Experts,
I just installed Oracle 11g on Linux Red Hat and need to run custom scripts. How can I run .sql scripts from Oracle Enterprise Manager?
