dynamic sql

Have you seen this

hi is it posible to create dynamic sql to create a select statement

Short answer: yes ;-)

BUT: what exactly do you want to do?! you provide little information about your "problem"...

i have table employee which got col1.co3,col2 etc until 50 columns

i what to write select for those 50 columns is there a dynamic way i can do that

Thanks, but this is still insufficient. I have no idea what you want to do?!? Where do you want to create/use/execute that SQL statement?! You should tell us some more ;-)

There are ways to build a SELECT statement dynamically (e.g. via 'execute immediate' or dbms_sql), BUT if we don't know what you're supposed to do, then there can't be an adequate solution...

Whether this is good or not, you gave half of the answer yourself ;-)
Now you may select this value into a variable and do an "execute immediate..." from within PL/SQL for instance...

correct