Step1. Up to now, we have a select query with required fields separated by commas and also as per the rule the host variable/target variable LT is prefixed by @LT. This is fine but we have a where condition. This gives a syntax check error. So the rule is if the fields in the select query are separated by commas then the host variable/target variable may be the work area or internal table should be prefixed by the escape @ character and also all the parameters in the where condition should be prefixed by escape @character.
Step2. So make condition as " where carrid = @p_car . " So there is no error. Execute it.
Step3. Provide the I/P and execute.
Step4. O/P:
-----------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment