Recent content by dbomrrsm

I am trying (with SQL) to convert an XML type column to a database table. I can do this using XMLTable succesfully until I come across multiple repeating groups. When I encounter the first node that can repeat I can manage to handle this but if withing this repeating group I encounter another...

I am trying (with SQL) to convert an XML type column to a database table. I can do this using XMLTable succesfully until I come across multiple repeating groups. When I encounter the first node that can repeat I can manage to handle this but if withing this repeating group I encounter another...

Hilfy Thanks for the information I will give those things a try and let you know how I get on. Cheers dbomrrsm [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in production - Edward Tenner

I am trying to import a webintelligence report from XI Release 2. The import wizard seems to run ok and indeed creates the folder structure on the destination(R3.1). However, the report itself does not appear. I have tried this with what feels like every single combination of options in the...

Dagon I suspect you are very correct - suppose the best way to stop it having to update ALL is to include the rows you want to delete in the update where clause. Thanks for your comments [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in...

Dagon I hadn't tried it but from what your test shows to enable the delete it appears that you must be updating the row to also be able to delete it. My first example above isn't updating rows where s_code = 160 hence none of the rows are deleted. As in your test above there is no where clause...

Dagon Thanks for your response. I looked up the merge and found a delete example at http://www.oracle-base.com/articles/10g/MergeEnhancements10g.php It has the following MERGE INTO test1 a USING all_objects b ON (a.object_id = b.object_id) WHEN MATCHED THEN UPDATE SET a.status =...

DDL: CREATE TABLE table_a ( pid VARCHAR2(13), d_code VARCHAR2(3), s_date DATE); CREATE TABLE table_b (pid VARCHAR2(13), d_code VARCHAR2(3), s_date DATE , s_code VARCHAR2(3),m_s VARCHAR2(1)); Script: insert into table_b (pid,d_code,s_date,s_code,m_s)...

[code] select username,max(datelog) from table_1 group by username [code/] [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in production - Edward Tenner

SELECT REGEXP_SUBSTR ('a,b,c,d,e,f,g,h', '[^,]+', 1, LEVEL) pivot_char FROM DUAL CONNECT BY REGEXP_SUBSTR ('a,b,c,d,e,f,g,h', '[^,]+', 1, LEVEL) IS NOT NULL [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in production - Edward Tenner

I have set up a linked server to an oracle DB to pull some data. However, when I run any query passing the pk of the row I am after all I can see in Oracle is the query doing a Full Table Scan. SQL Server does not appear to be sending the where clause as part of the query to oracle but appears...

When a package is called as part of another package the outer package has to wait until the called package completes before it can continue. Is there any way the calling package can continue with its processing before the called package completes ? TIA [bandito] DBomrrsm [bandito] Software...

Is this at all possible in pl/sql: IF (select 1 from dual) = 1 THEN -- Do something ELSE -- Do Something Else END IF; I appreciate that you can populate the calue of the select statement into a variable and use that in the if but just want to know if the above is possible in any version of...

I have a HP hw6515 pda and a spectec minisd wlan 11b card - I have installed what I think are the correct drivers and there is an icon in programs called WLAN - however when I click on this nothing happens - I did at one point about a year ago get this to work and I have just spent about 3 hours...

blom Thanks very much. dbomrrsm [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in production - Edward Tenner