Using Dynamic SQL with Oracle

I am new to database programming, I am required to generate some dynamic SQL queries but am not sure what to do and where to start from. So, I don't have any sample to share.