Search results for query: *

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...

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...

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)...

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...

I am trying to get the results of a Business Objects report (.rep) file to save as text to a server location. The task keeps on failing I think due to the permissions on the folder where the BCA is trying to write the file to. The folder has been set to allow BOADMIN account access to write...

Very quick question: What would be more efficient: IF var_a = var_b THEN IF var_c = 101 THEN Do something...... END IF; END IF; OR IF var_a = var_b AND var_c = 101 THEN Do something...... END IF; Or would there be very little difference ? TIA [bandito] DBomrrsm [bandito]...

In Webi 6.5 when a user drills outside the original context of the report a new query is sent to the database. In Webi this creates the sql with a where clause of the last item drilled so if a user selects department A to drill on the sql has a where clause of where department = 'department a'...

I have a universe where there are two tables that join together with a straight forward join. In Webi I can generate a simple query with a dimension from one table and a measure from the other and the sql is produced correctly with the relevant join condition in the where clause. However...

I have obtained the following as an example of womething more complex I am trying to do: declare TYPE ARRAY IS TABLE OF all_objects%ROWTYPE; l_data ARRAY; CURSOR c IS SELECT * FROM all_objects; BEGIN OPEN c; LOOP FETCH c BULK COLLECT INTO l_data LIMIT 100; FORALL i IN...

I have a cursor that I fetch using bulk collect into an array. I then use FORALL x IN a_array.FIRST..a_array.LAST and do an update of tablea with a where condition of: field_a = a_array(x); - this works fine I then need to delete from a different table so do delete from tableb with a where...

Will a Select * from TableA where rownum < 10 always return the same 9 rows (assuming the table hasnt changed). TIA [bandito] DBomrrsm [bandito] Software code, like laws and sausages, should never be examined in production - Edward Tenner

I have a table with one column with 48251 rows in all with distinct id's so: select count (distinct event_number) from ZBI_SIEBEL_CUST_CONTACT_OS_ITEMS gives the reults 48251 I then do: select count (distinct event_number) from ZBI_SIEBEL_CUST_CONTACT_OS_ITEMS where event_number not in...

Very new to SSIS so please excuse my ignorance. I have managed to populate variables with the results of a script - example: declare @var1 int set @var1 = 1 Select @var1 However, what I need to know is if it is possible to populate a package and/or task variable with the value of @var1...

I have two tables in different databases that are exactly the same in structure. I have added an additional column called test to tableA. When I run the below code the NOT IN finds the difference between the tables (i.e. the additional column called test) but the NOT EXISTS doesn't - can...

We have a number of databases that we need to move from 2000 to 2005. I belive this can be done using the restore database T/SQL command from a .BAK file of the 2000 database. Is it possible to copt the MDF file of a 2000 database and use that create the database in 2005. If there is a better...

I have a table (tableA) that holds a date field and I want everything from tableA where the date field is greater that the maximum date selected from a different table tableB. The difficulty I have is that tableA's date field is a date data type and the field from tableB is a varchar2 (23)...