Hi Experts,
How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block
Thanks for the help
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.
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
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
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?
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
Discuss This Question: 7 Replies
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.