Scarpozzi
Lifer
I'm stuck using a 3rd party user app with access to the database. I can develop queries, etc, but they all have to run through this app due to network security and security roles in Oracle. It's slow and restrictive, but hey...I'm on the clock.
I've not had to develop a lot of complex queries before... In the past, I've just run basic commands to let scripts create and populate tables....so this is new.
What I need is a basic editor that I can copy/paste my code into to check for all the operators, necessary punctuation, etc... I was trying to identify all my missing commas a while ago and started to lose my mind because they were nested...it's easier to spot errors when you can just run a code check. Anyone know of anything that's free and good for this?
I've not had to develop a lot of complex queries before... In the past, I've just run basic commands to let scripts create and populate tables....so this is new.
What I need is a basic editor that I can copy/paste my code into to check for all the operators, necessary punctuation, etc... I was trying to identify all my missing commas a while ago and started to lose my mind because they were nested...it's easier to spot errors when you can just run a code check. Anyone know of anything that's free and good for this?