I have 3 tables A, B, C. I have two different INSERT statements to insert into these three tables. I want to have a case statement which will decide which INSERT statement will run for which table depending on some condition. How do i put a case for this.
lIke --
Consider table driving_table--
table_name table_type
A STATIC
B STATIC
C DYNAMIC
Now i want to have a case which gives INSERT statemnt 1 when table_type = static or INSERT statement 2 when table_type= DYNAMIC