Recent content by davemans

If you right-click in a SQL window and 'Add to Project' you get a blank line in the list of items. I find this useful for seperating items into related groups. It would be good if you were prompted to save any changes in the Project window when you quit PL/SQL Dev and have forgotten to click...

Doesn't add leading comma(s) if the first column(s) are null. Null fields in the middle of a row are fine. Export with Smart Quotes was checked but unchecking it doesn't seem to disable it i.e. still only has fields containing commas enclosed in quotes.

As a workaround, you could do Ctrl-E and get it back from the Recall buffer.

In your code snippet You have an opening quote after the WHERE but no matching closing quote. The beautifier will not parse correctly if their are syntax errors in the code.

Could it be because the 'AND' is inside brackets? What happens if you remove them?

I think it is because there is no icon for a dimension. You can get them to display as tables by putting the following in the where clause for your folder :- owner = 'Dummy' union all select owner, 'TABLE', object_name, status from all_objects where owner = USER and object_type = 'DIMENSION'

This thread might help : http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002158

You can fool the browser to some extent by putting something like this in the WHERE clause :- Owner = 'Dummy' UNION SELECT field1, field2, field3, field4 FROM some_table field1 is interpreted as the user and is not displayed if the same as the connected user else it prefixes field3 which is...