How to create dynamic sql?

[Chhaya Dhanani]

hi all,
i am trying and still unable to figure out how to go about creating a dynamic query..
i have a before insert trigger on table "One"
in that trigger depending upon "categoryId"
i have to update different tables. How do i use DBMS_SQL package in my trigger to do this?
for eg:
depending upon categoryID, my dynamic query would be as follows:
update catgeoryId_master set status='SCHEDULED' where userid=variable;
here both the table name i.e categoryID_master and userid will be dynamic
how do i accomplish this?
This is an SOS.. reply soon
Thanx in advance..
Oh! wat would i do if not for Javaranch??
Chhaya