I am trying to repeat the samples in this post, but run into some errors:
http://www.oracle.com/technology/pub/articles/quinlan-xml.html
I have 0 knowledge about XML and Oracle XMLDB
If you...
SELECT * FROM user_constraints uc WHERE
uc.constraint_type = 'C' and uc.search_condition LIKE '%NOT NULL%'
but since uc.search_condition is of type LONG, this crashes. ORA-00932 i...
Hi
I have an Oracle table with some XML stored in a CLOB and I was wondering if there was an easy way to look for certain values or SELECT out values from the XML using regular PL/SQL?
E...
Hi,
I logged into a newly created APEX environment
and went to the Home>SQL Workshop>SQL Scripts
and got the following error:
Invalid exists/not exists condition: ORA-01775: looping ch...
Hello,
I think this is not the first time this question is being asked.
I am using oracle 10g on vista.. suddenly i started facing difficulty in login in using the host name orcl. I'm ge...
Hi,
Wht is the purpose of ANALYZE command. if we ANALYZE the table/index wht happens to the object and how it improves the performance? Because why i am asking is, I have table which is conta...
I'd like to rename an Oracle sequence - can this be done?
I'm trying to measure the performance of an application that heavily relies on an Oracle 9i database. I capture the time it takes to accomplish certain application specific routines and I wou...
Dear Expert,
Can anybody teach me what is dynamic record group in oracle forms.And how i can effectively
use it in in forms 6i.
Please teach me in nutshell.
Thanks & Regards,
Priya
I have a form in Oracle APEX that is using a Named LOV to allow the user to select 'YES' or "NO' for grant requested. These values are being written back to a table that contains 1 for Yes and...
Hello, I have a fairly simple query im trying to do, but im getting the syntax wrong somewhere. Basically I have this query which would yield the following.:
select distinct sector from sym.s...
Hello, i'm trying to execute querys like this one :
insert into mytable (username,domain,firsname) VALUES ( 'user1', 'domain1', 'D'Artanian' ) ;
the single quote on D'Artanian cause : ORA...
Using Crystal Reports XI. I can't make a file with all the records are on one line each of 148 characters in length.There is a combination of txt and number columns that I tried concatenating ...
How do I keep a running total in Oracle SQL
I am getting following error in alert log.
OS: HP-UX B.11.23 U ia64
WARNING:Oracle process running out of OS kernel I/O resources
Oracle Database Server" status is INVALID after applying 10.2.0.4 PatchSet.
Oracle Database 10.2 Upgrade Status Utility 08-31-2009 10:58:04
.
Component ...
My company is looking at starting a NEW project. I am looking for expert opinions on which Oracle version to go with, 10g or 11g.
The DBs running on this server will be pretty big, 1-2TB and ...
Can anyone tell me what is wrong with the following code block in Oracle?
set serveroutput on;
DECLARE
strAccess VARCHAR2(100);
cursor curAccess(v_Physical_instance_uid NUMBER)
IS
se...
Dear Experts,
I have a code below.
1. select statement
it selects start_date from the employee;
2. declaration
compares the array elements with the start_date of employee.
My ...
Hello
currently i m using firebird. i m just wondering what will be the advantage on firebird if i move to oracle or db2 or mssql.
oracle is expensive but is it worth to look in to it ?
...
I want to save the excel file as pipe delimited.
i tried to do this....
save as (tab delimited) and then
cat xxx.txt | tr '/t' '|' > yyy.txt
Issue: some rows are good. But some ar...
Hello all,
I am trying to refresh a materialized view on demand using a trigger while a insert/update/delete happens on a base table. I called a procedure through a trigger to do a refre...
I am working an a Visual Studio 2008 C# application connecting to an Oracle 10.2 database using built in .NET data object for Oracle.
My code as exists looks like:
da.FillSchema(sourceDt...
I have created xyz.sql sql script file with two basic stored procedures inside it like
create or replace PROCEDURE AddCUST(
p_CUST_id IN VARCHAR2,
p_first_nm IN VA...
Experts,
I created a Password Verify function by entering the following:
connect to each db instance as
sqlplus /nolog
sql>conn / as sysdba
sql> @c:\PwdVerify.sql
however I ge...
