Hello,
Seem to remember that this has been posted before, but could not find anything relevant after a cursory search.
So, I recently got this following script snippet:
alter database datafile ‘dummy_file.dbf’ online;
recover datafile ‘dummy_file.dbf’;
alter database datafile ‘dummy_file.dbf’ online;
alter tablespace a_tablespace drop datafile ‘dummy_file.dbf’;
I copied it in SQLNav, selected it and did CTRL-R to format the code:
ALTER DATABASE DATAFILE ‘dummy_file.dbf’ ONLINE;
recover datafile ‘dummy_file.dbf’;
ALTER DATABASE DATAFILE ‘dummy_file.dbf’ ONLINE;
ALTER TABLESPACE a_tablespace DROP DATAFILE ‘dummy_file.dbf’;
The “recover datafile” statement stays lowercase…
On the other hand, when I just type in the statement, both words are uppercased as soon as I type “space” after each one (so it does recognize them as keywords then - preference “Keywords to Uppercase” is set).