ThatJeffSmith

Tag: extension

Customizing File Extensions for Your PL/SQL Code

You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies […]

How to View Errors for VIEWs in Oracle SQL Developer

I know, who has errors in their code? I don’t have errors because I don’t write code. But for the rest of you, it’s possible you have inherited someone else’s problem. And that problem might be an invalid VIEW. You can tell your view has a problem because of the big, sad, red X Oracle […]

Using XML Extensions in SQL Developer to Extend SYNONYM Support

This is a pretty old topic as far as SQL Developer goes. There are public articles going back to 2007 that show you how to extend the functionality in SQL Developer via SQL and XML. But I’m going to guess that for many of you that this is a new subject. Knowing that extensions exist […]

Related Posts Plugin for WordPress, Blogger...