Carlosdl   29855 pts.  |   Dec 9 2008  2:29PM 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.

Inprise   540 pts.  |   Dec 10 2008  4:44AM 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

Carlosdl   29855 pts.  |   Dec 10 2008  8:42PM 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.

Inprise   540 pts.  |   Dec 11 2008  4:01AM 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

Inprise   540 pts.  |   Dec 11 2008  8:46AM 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?

Carlosdl   29855 pts.  |   Dec 15 2008  4:23PM GMT

Is there any specific reason why you must use REGEXP ?

Inprise   540 pts.  |   Dec 16 2008  6:57AM 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