i have an issue which is driving me crazy.
say I have the table
i am not logged into apps but another schema
say i have the select statement
from apps.po_vendors p
i then want to edit the select and replace the * with a column name. I remove the *
I enter p and then press the ^. i select the column from the drop down ie vendor_name.
Rather than leave this as p.vendor_name toad translates this to apps.po_vendors.vendor_name. I dont want this behavior. Is there a way to turn this off. i’m on 10.1.1.8