Home » SQL & PL/SQL » Client Tools » syntax file (10g)
syntax file [message #463686] Fri, 02 July 2010 10:31 Go to next message
geneeyuss
Messages: 53
Registered: June 2010
Member
could I know if anyone can send me a syntax file for PL/SQL for editplus. I would want all the reserved words to turn to CAPS once I enter and reserved word and press the space bar. Also to color highlight the reserved words

Thanks in advance
latha
Re: syntax file [message #463689 is a reply to message #463686] Fri, 02 July 2010 10:36 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Well, I dont know what you are going to do in editplus
But yes you can get the list of reserved words from v$RESERVED_WORDS.

You can work with tools like Toad, Oracle sql developer etc where
keywords are being highlighted. Or, In Notepad++ got to Language>S>SQL to view the code


Thanks
Ved
Re: syntax file [message #463690 is a reply to message #463689] Fri, 02 July 2010 10:41 Go to previous messageGo to next message
geneeyuss
Messages: 53
Registered: June 2010
Member
i dont have access to Oracle sql developer or Notepad++. also I cannot do everything in TOAD. I will need tools like editplus to perform tests.
Re: syntax file [message #463691 is a reply to message #463690] Fri, 02 July 2010 10:46 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
geneeyuss wrote on Fri, 02 July 2010 10:41
I cannot do everything in TOAD. I will need tools like editplus to perform tests.

What test? What you want to do with Editplus and think that you can not do with Toad? Would you please let us know?


Regards
Ved

[Updated on: Fri, 02 July 2010 10:48]

Report message to a moderator

Re: syntax file [message #463692 is a reply to message #463690] Fri, 02 July 2010 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can get some files here
http://www.editplus.com/javacpp.html
If you are not happy with listed options, create one for yourself.
But I dont get the point. Editplus is just an editor.
Oracle SQL Developer is free and way better integrated.

[Updated on: Fri, 02 July 2010 10:50]

Report message to a moderator

Re: syntax file [message #463694 is a reply to message #463692] Fri, 02 July 2010 10:54 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
What I know is Edit plus is an Editor like Notepad++ that offers features for Web page authors and programmers. Syntax highlighting language and provide FTP commands to ftp server

I dont know if there is a way to execute query on database with an ODBC driver or some other way. I don't think so

Regards
Ved

[Updated on: Fri, 02 July 2010 10:56]

Report message to a moderator

Re: syntax file [message #463695 is a reply to message #463694] Fri, 02 July 2010 11:11 Go to previous messageGo to next message
geneeyuss
Messages: 53
Registered: June 2010
Member
because of security reason I dont permissions to download these softwares on my laptop. secondly we do a lot of commandline testing for which we write scripts. i use editplus to write these scripts.
Re: syntax file [message #463696 is a reply to message #463695] Fri, 02 July 2010 11:13 Go to previous messageGo to next message
geneeyuss
Messages: 53
Registered: June 2010
Member
btw i looked at http://www.editplus.com/javacpp.html
they have a lot of syntax files which do different things. not sure which one is the latest. I picked up the latest for 9i which doesnt CAPS the reserved words when I press the space bar. so am not sure which one to pick up from there. hence this post.

thanks
Latha
Re: syntax file [message #463710 is a reply to message #463696] Fri, 02 July 2010 12:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It works for me.
As said before, you can customize it however you want.
Here is a demo.
  • Attachment: editPlus.swf
    (Size: 724.49KB, Downloaded 909 times)
Re: syntax file [message #463712 is a reply to message #463696] Fri, 02 July 2010 12:30 Go to previous message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Meanwhile, I used plsql4.zip
Previous Topic: heading for every 10 rows
Next Topic: Installing Toad on Ubuntu 8.04
Goto Forum:
  


Current Time: Fri Oct 18 18:21:40 CDT 2019