Why is my SQL file I just spend 5 days on suddenly overwritten?

        I have a query block that I need to repeat several times in my underlying SELECT statement, how can I use the same code without having to repeat the code in each block and creating a new view?

        I need to get previous and next row's value, how can I do this without having to use subqueries in my existing query?

        I need to extract the ddl about a specific object programmatically, what is an easy what to accomplish this?

        I need to pass parameters into a view, but Oracle doesn't support this functionality.  How can I accomplish this task?

        We will go into these questions and much more in the talk as we discuss some of the Tricks that you should know about while writing Oracle SQL as well as some as some of the Traps you may encounter while you develop your code as well.