- #Pl sql developer download free full version drivers#
- #Pl sql developer download free full version Patch#
- #Pl sql developer download free full version code#
- #Pl sql developer download free full version windows#
Growth in those areas is where I would see the biggest benefit, but also a very big benefit in how I can connect and say, "Let me see what's going on," and I actually can get a snapshot of what's happening at that moment in time, what opportunity in the future could we push that, as it automatically refreshes that information. It gives the developers the ability to say, "Oh, I ran the SQL and here it is outside of the normal suite of tools that Oracle has" just something very simple to look at and go, okay, I can see how this is impacting the system. Growth in a monitoring perspective is something that I would like to see as it relates to the tool. That dashboard screen that you can now pull up has definitely moved in the direction that allows DBAs to go through there. That's great, but - and this is just feedback that I get from DBAs - some of the features that it deals with, with their role in exploring what's happening in the database, are not there. They've done a great job with providing or producing a dashboard screen very interesting metrics that you want to see as it relates to what's going on with the database. Some of the tasks that the DBAs have to do could be worked out a little bit more. Some of those components are just not included.
#Pl sql developer download free full version drivers#
You've got to go find the drivers for connecting to a DB2 database or connecting to even a MySQL database, which is now all by Oracle. There are always areas of improvement as it relates to the tool's ability, the process that you need to go through in order to connect to some of the non-Oracle databases. It really streamlined a process that we had integrated. The Cart file included all of the coding that we needed our DBAs to execute on, to deploy into our development production environment space, to put our changes in. We eliminated kind of the question-answer piece between what the developer wanted and what the DBA was trying to do, because we were able now to encapsulate all of that into this Cart file. They didn't have to come back and ask us anything.
#Pl sql developer download free full version code#
We were able to use the tool itself, SQL Developer, to do that packaging for us and then with all the surrounding code needed to actually deploy that, and just pass that off to our DBAs who can then just execute that series of commands. That really allowed us to make sure that all the files and all of the components of any particular project we were working on were together, because we're not trying to copy this SQL file and put it over here, and this database definition, this table definition file in SQL over here, and grab a bunch of different things and stick them in a shared drive.
They could take SQL Developer on the back end, open that cart up and basically deploy that through whatever environment. We can then just send them basically this shopping cart.
#Pl sql developer download free full version Patch#
The Cart feature, which came out I think around version 4 or so of SQL Developer, allowed you in the tool itself to select all of those components that developers had been working on, patch them up into a file that included everything our DBAs would need in order to roll that onto production. Our process before was my developers would create some type of PL/SQL script, it could include DDL, a creating table, grants/permissions, obviously the scripting behind that, and we would take those series of files, we would put them on a shared drive on our network where our DBAs could then go get those files, and then promote them into our production environment. It allowed you to really streamline processes. When I was reviewing some things in SQL Developer, one of the things that jumped out at me, especially in a former job a couple years ago, was the Cart feature. That's been a really good feature that I've appreciated in SQL Developer. Now I can pull up and have multiple views of code running, and I'm able to lock that code, lock the results of queries in, so that I can see the differences between the things that I'm doing and if I wanted to change something, what the outputs will be.
#Pl sql developer download free full version windows#
Basically, exploiting Windows features that are now available, it lets me kind of take advantage of having a really huge 30” screen.
I'm now able to split out windows that I couldn't do before. That's part of it.Īs far as a specific valuable feature, outside of just mentioning how it seemed the tool itself matured overall, is its modularity. The formatting and the UI's getting a whole lot better. It has the ability to manipulate code right there on the screen. The most valuable features, what I tend to now use the most, outside of the change they've made in the IDE itself, are how it's become more flexible and the maturity in the IDE itself. They've done so many things that have made that product just so great.