carlosdl Dec 9, 2008   2:29 PM GMT

Hello Inprise. Could you please provide more information about your question ? Maybe if those attributes (location, city, country) are fields of a pl/sql table, and what the structure of that table is, and what exactly you want to accomplish. Some example data would help also.

84,495 pointsBadges:

Inprise Dec 10, 2008   4:44 AM GMT

Hello, I need a logic that checks for example p_location is not allowed to start with values (neither p_city nor p_country) as all this are parameters of my procedure and are from same table additional i shud one more parameter cname which from different table So logic is to check p_location not allowed to start with values p_city,p_country nor cname . I don't know wat logics can be applied n my PL/SQL block for this .. thanks n advance for ur help

610 pointsBadges:

carlosdl Dec 10, 2008   8:42 PM GMT

I'm still not sure if I understood correctly your question. How about something like this:

  if p_location like p_city||'%' or p_location like p_country||'%' then
  		dbms_output.put_line ('something');
  End if;

Please confirm if that's what you meant, so we can put this as an answer.

84,495 pointsBadges:

Inprise Dec 11, 2008   4:01 AM GMT

Hi, No not this way i think i shud use REGEXP_LIKE or REGEXP_INSTR or REGEXP_SUBSTR not sure which is to be used as it needs to check 3 different paramater i am trying out .. But what i am still not understanding is how this check can be performed on 3 parameters and it shud actually not take values of this 3 parameter means how will be the output

610 pointsBadges:

Inprise Dec 11, 2008   8:46 AM GMT

Hi i used this way in SELECT QUERY its compiling not sure whther its correct logic NOT REGEXP_LIKE (v_location_name, '^', 'i' ); Anyhow thanks for ur suggestion and pls let me know my logic s correct or not?

610 pointsBadges:

carlosdl Dec 15, 2008   4:23 PM GMT

Is there any specific reason why you must use REGEXP ?

84,495 pointsBadges:

Inprise Dec 16, 2008   6:57 AM GMT

No specific reason ,is there any other way i can do this comparison then tat wud be well good as this uses SELECT stm whihic is a overload again (time of execution) thanks n advance

610 pointsBadges: