Recent content by alanmoor

This has been a problem since v7 and I was hopeful it was fixed in v9. The issue occurs when using the arrow keys to navigate through lines in the program window. It can take upwards of 5 seconds to move the cursor to the next line. Then it clears up for awhile (or catches up). It's very...

Whether to create or replace? If it exists, replace it, if not, create it. Generally speaking, the advantage of CREATE vs CREATE OR REPLACE is that the CREATE will fail if the view already exists. When to get column names from dba_tab_columns (or user_tab_columns) for views? ALWAYS. The...

Whether your preference is "select x as y" or "create view (y) as select x", the point remains that the tool should support all syntactically correct variations. Stepping off my soap box now, Cheers, Alan P.S. Have been using the product for several months now and really do like it.

What tripped me up was the aliasing of column MBR_EXPIRATION_DT to MBR_EXPIR_DT. Note also the "WITH READ ONLY" clause at the end. Thanks for taking a look at this. CREATE OR REPLACE VIEW MZ_CANCEL_MBR_V ( MEMBERSHIP_KY, MEMBER_KY, ASSOCIATE_ID, MBR_NAME, PAY_AMT, DUES_AMT, MBR_EXPIR_DT...

No, when you right click on a view and select "edit", it pops up a sql editor with a statement like: create or replace view xyz as select something from somwhere instead of: create or replace view xyz (someothername) as select something from somewhere When you save the view, the view will...

Just ran into a disturbing "feature". When you edit a view, the column aliases are not included in the generated SQL. If you save that view, you have just lost all the aliases, (as I just learned from my testing team). Things break, people get all upset, and it just sort of ruins your day...