Search results for query: *

That got it. Thank you so much. I was leaving out the initial select and the extra set of ''. That is exactly what I needed. Once again, you are major help and a wonderful source of knowledge. I will again give you star. I have a feeling you might have a few of those in your profile. HA...

thank you for the insight. If we take cold fusion out of it and just wanted to run in pl/sql developer to get a list, is there a way to do it without running a procedure and just from a straight sql statement? Thank you again for taking the time to help.

I was hoping to just run it as a stand alone sql statement in pl/sql developer. The ultimate goal is to have the sql script be used in a cold fusion process that displays all of the items. If I put it into a procedure I guess I can put the results in a variable and then call the variable in the...

I have a table promotion_schedule that has a field called "where clause". This actually has the where clause used to pull certain items out of another table. If I do a: select where_clause from promotion_schedule it will give me the following: ((acntv.master_sku.retail_cat='some...

It would still return null. The initial portion of the cursor should only provide items that are within +-1 of the passed size requested.

Dagon, I'm sorry, I just got back in the office. If a 5 was passed and the only thing was a 3, we would want to pass a Null value. KKBrwnDBA, That makes sense, in theory, however, putting that in practice is something I've never done, nor know where to begin :( Thank you all again for your help.

The cursor should be pulling anything that is within 1 size up or down of the passed parameter size. That could include a full size or a half size up or down. The next closest size could be the full size(if thats the only one available) but it could be a half size as well. If I passed a size...

To point 1, if there is more than 1 size available, then the next smallest size. If there is only 1 size available, then doesn't matter if larger or smaller. To point 2, if there is only one result from the cursor, then null, if more than 1 then it will return the next closest size on the...

I have a cursor that pulls product_id and size and orders them by size asc. I'm passing a size and number(either 1 or 2) to the function. basically what I'm needing to do is return the size that is the next closest to the size I pass in. The issue becomes when I have more than 1 size...

Jimirvine, I hope something like that can work. Let me provide some examples and see if I can make sense of it. MASTER SKU TABLE master_id ABC123 FGH567 XYZ890 Ensembles_prod_rec TABLE master_id1 master_id2 score ABC123 acbde1 .33 ABC123...

Dagon, I'm not sure I follow completely. Would I need to manually create the "insert into ordered_row values (1, 'X1', 1);" the tables I am using will be truncated and repopulated daily based on a number of criteria. So everyday, the master_ids will change, as will the items I am joining with...

This does speed it up a little, thank you. I'm still thinking it shouldn't take this long. Still 100 rows/45 sec. Using the function you provided above the whole sql query is: select m.master_id, customers_x(m.master_id,m.product_id,1), customers_x(m.master_id,m.product_id,2)...

I have a sql query that pulls about 26000 rows in about 3 min. I have added another column that calls a pretty simple function, but it changes the efficiency to about 100 rows/2 minutes. I really need to add three columns using the same function, but at this rate, it would run all day. The...

i agree whole heartedly. It is done. :)

Thank you so much. Worked like a charm.

I have a function that has three parameters(v-mid,P_product_id, n). Inside that function I need to call another function called top_related_prod_type2 that have the same three parameters that were passed to the main function. The synatx around it looks like this: if v_no_of_records < n then...

Also, if I pull out the insert statement and run it outside the procedure replacing the parameters with values, it runs fine. So I'm thinking the v_clause is the issue somehow.

I don't know if you saw the post I just sent out. If you did, I'm not sure what else I can tell you. The to_char(iss.where_statement) is to convert from a CLOB.

Here are the two procedure I have currently. create or replace procedure test_dynamic_procedure is begin DECLARE CURSOR ao_cur IS select pg.id,to_char(iss.where_statement) where_clause from report.product_group pg, report.intelligent_shops iss where pg.id=iss.group_id and...

Okay, I'm in a major crunch here. Here's what I have. There is a gui that allows users to select filter criteria. Each product group can have multiple groups with individual filters in it (ie. Gold month could have a gold rings shop,a gold necklace shop, etc each with their own filters)...