Set define off permanent
When running queries in SQL Developer and using the character & in my literals, a popup appears asking me to provide a variable. I then execute SET DEFINE OFF; and I can run my query for the rest of the session.
Is there any way to configure Oracle so it can never ask for manual variables when containing the & character?
Create a text file on your PC which contains set define off and any other set-up instructions you might want.
Then in SQL developer, go to the Tools menu and pick the Preferences... option. In the panel on the left click on Database.
Then either type the path to the file you created, or click Browse and navigate to the file in the 'Select connection startup script' dialog that appears.
That script will then be run every time you connect to any database.
- How to select rows with no matching entry in another table?
- Get count of id for each day and Group by date
- How can I replace a string in a MySQL database for all tables in all fields in all rows?
- Date set in parameter does not match with date when querying the parameter
- Getting error recursive reference to query must not appear within its non-recursive term in postgres
- sqlcmd how to run a query against specific database?
- SQL query engine for text files on Linux?
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- Time and Attendance query, First transaction of the day per person
- How do you execute SQL from within a bash script?
- How to write this SQL query to find each account balance?
- How do I speed up querying my >600Mio rows?
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- Why is "connection.queries" returning an empty list in Django?
- Extracting value from comma-delimited string in Teradata
- How to sort all numbers before letters with linguistic sorting?
- How to add multiple columns in AWS redshift with alter table query
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL query left join with sum,group by and order by in MS Access
- Update an existing sql table based on content from an external csv file?
- SQL Formatting a string (name)
- Oracle Sql Statement for unique timestamp for each row
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How do I suppress T-SQL warnings when running a script SQL Server 2005?
- How can I group time by hour or by 10 minutes?
- SQL syntax error when trying to create a new table using TypeORM
- How to use PERCENTILE_CONT without over clause? any alternative to it?
- Success message for an end user inside an SQL procedure
- Does Oracle field contain all letters from a string?