Kris' blog

Sqldev talk in St. Louis

2008-05-27T14:44:00.001-07:00

In case anyone reads this is in St. Louis there's a user group meeting Friday at Ameren details are here: http://www.missourioracle.com/

Clob read speeds over jdbc

2008-05-23T16:13:00.000-07:00

Thought I'd pass on some findings on clob read speed over jdbc. In sqldeveloper , when you select #clob# from #table# the tool shows the first ~80 chars of the clob. I spent part of the last 2 days timing the fastest way to read clobs from the db. I mostly work on remote databases so I notice when network latency start getting high. In looking at java.sql.Clob there's a few way to get the text.

Who needs to store a password.

2008-04-17T12:32:00.001-07:00

In sqldeveloper 1.5, if you don't want to have the option of saving the password for a connection try this: Edit the sqldeveloper/bin/sqldeveloper.conf and add this: AddVMOption -Dsqldev.savepasswd=false Adding this will remove the checkbox to have the ability to save the password. I added this a while back and forgot until a recent post on the forums reminded me. A customer needed to for some

Sorta off topic

2008-04-16T10:34:00.000-07:00

This is only Oracle in that it's at HQ in the lobby of the 500 building. I've been loading my pictures to flickr and found this one that I had forgotten about.

Which tnsnames?

2008-04-16T08:41:00.000-07:00

It seems to come up often that some people are unsure where the list of connections get picked up from. So, if your not sure which tnsnames file sqldev is using try this: 1) Open any worksheet Sqldev just needs someplace to process the next command and doesn't actually use the connection for anything. 2) Enter : setloglevel oracle.dbtools.raptor.utils INFO This sets the java logging level on

not it..

2008-01-10T21:54:00.001-08:00

I was wondering if I would get out of this since I only blog about once every couple months. Here goes 8 things. 1. First pay back to Carl for tagging me... My son beat Carl at Burnout ( my son was 6 at the time ) 2. Made one of these a couple weeks ago with my son. 3. I've jumped out of planes and helicopters 4. I'm a ham , N1JLX. My first post to the internet shows that. 5. I ride a Honda

One of many ...

2007-12-05T11:20:00.000-08:00

There's lots of little things in the upcoming release of sqldev. Frank's post reminded me of one that I forgot to show at openworld. We have support for the same DVT Gauge component that he mentions in sqldev's next version. However, all you have to do is write a sql statement. It's really simple to use. For example, I took the free space report from Tom Kyte and added guages. The only you'll

Oracle Open World

2007-10-27T20:45:00.000-07:00

Open world is almost here. Here's my connect card. I'll pretty much be at the booth or between our sessions. Stop by if you want to chat.

Subscribe to Public Reports

2007-10-24T16:42:00.000-07:00

Mark's post on the forums got me to do something I've been meaning to do for a while. I updated the reports section of the exchange today so that you can upload a report.xml. Now when you goto "My Reports" There's a file upload to load the whole xml file. This should allow people to post reports with children or whatever is in the xml. Also I made this link for getting all public reports

What's up

2007-06-08T08:38:00.000-07:00

I forgot I added a real simple way to see what DBs are up in sqldev a while back. If in the worksheet, you run a command, F5 (run script), "pingall" it will do a tnsping of all the connections defined and report back. From this screenshot you'll notice most of my DBs are down. My plan was to hook up an indicator in the tree for down database but never got it well tested.

More Apex/SQLdev

2007-06-05T15:06:00.001-07:00

Here's a couple more shots of the up coming Apex and SqlDev intergration. 1) Export your app: 2)Import the app: 3)Import Options:

SQL Injection scanners

2007-05-21T17:29:00.001-07:00

Here's a list of the free sql injection tools over on security-hacks.

Releases

2007-05-17T10:29:00.000-07:00

In the last week, the team has released 3 times. 1) SQL Developer 1.1.3 was released 2) Jdev 11 Preview was released where sqldev is built in 3) SQL Developer Migrations EA #2 was minutes ago posted. If your running 1.1.3, you'll see the update balloon soon. However, I looked up some stats on usage and the majority of people are using 1.0.0 which was release March 2006. Here's the release

Process a zip file

2007-05-15T16:02:00.001-07:00

Some one on the forum asked for an example of how to bulk upload files. Here is an example I used a couple years ago of processing a zip file and uploading the individual files into a table. Then we made an application to manage the file and followed "Create a Procedure to Download Documents" to download. Here's the sql for the table and sequence: create table docs(doc_id number,blob_content

New patch with APEX features

2007-05-10T10:23:00.001-07:00

I just pushed sqldeveloper 1.1.3. There's about 200 bug fixes in this build some more visible ones are here. There are a couple new things like a couple more sqlplus command supported , print , accept. The other thing that you will notice is new reports. Mike Hichwa added some reports for Application Express. So now you can easily see the applications you have access to and some details

csv with sqldeveloper

2007-05-03T08:46:00.000-07:00

Laurent shows how to format a select * into csv. Give this a try in sqldeveloper, simply add a comment in the select and it's csv. See this:

Interactive Reports part 3

2007-04-16T16:27:00.000-07:00

The next step to having all these great reports in xml files would be to organize them. This one is the simplest by far. The name of the folder is split on the / and sub folders are made. This is very handy when a report gets into 100s of lines of xml since the reports can now be stored in multiple files but foldered together in the tool. Like in sqldev the "Data Dictionary Reports -> Database

Interactive Reports part 2

2007-04-11T16:07:00.000-07:00

In this post, I'll show how to add a context menu to a report. The same thing can be done to a tab which has been added which is described in Question #1 here. For more on the tag see this post. For more on the tag see this post. Here's an xml file of the 2 combined. The things to look at are that the is inside the . Then look at the bind variables :

Extending the Navigator with children

2007-04-09T17:07:00.001-07:00

I started to answer this question with a reply to the comment but thought I'd just put a post together since this is should make it easier to find. Question #3: Do you have the xsd file ? There is an XSD for the navigator in sqldev 1.1 and it's located here. In the xsd you'll notice there's quite a bit that I didn't mention before. Question #2: How to add multi-level folder like "Storage" > "

Interactive Reports part 1

2007-03-30T16:40:00.001-07:00

The reports in sqldev 1.1 change a lot. Among the changes are different types of reports, master details , context menus and drill downs. Alot of these features can be created/changed by the Create Report dialog but a number of them can not. I'll try and explain how to do things not in the dialog in the next few blogs working up to a interactive report which will show how to add these to your

Targeted Job Ads?

2007-03-29T11:19:00.000-07:00

While checking my gmail, I noticed this sponsored link. Targeted job ads based on history seems like a very easy use of the massive data google compiles.

Add the ability to make a connection read only

2007-03-02T15:26:00.001-08:00

To show how simple it is to add functionality to the context menus in sqldeveloper without writing any java like I posted before about. I'll take a case which was on the forums today about how to make a connection read only. As most people probably know there's a set transaction read only; command which can be issued which prevents the session from issuing updates. To make it easy to toggle

Better APEX urls

2007-02-22T22:00:00.000-08:00

I was cleaning up a webserver and found this code I wrote a few years ago to help make HTMLDB now Application Express entry points nicer. Hopefully everyone knows Application Express and uses it everyday, if not you should go sign up and kick the tires at apex.oracle.com. Prior to working on SQL Developer, I did some work in Application Express and built some internal systems with Carl and

Sql Worksheet Tips

2007-02-22T21:00:00.000-08:00

in a sql worksheet try some of these: ctrl-shift-0..9This will pop the 0-9th sql form the history and replace the current sql worksheet contents. The rest need to be run as if they are scripts ( F5 ): Want to change the tab in the worksheet while a script runs to see an easy status. set worksheetname hello Working on APEX or mod_plsql routines? set owacgienv on set getpage on begin

Learn something new everyday

2007-02-19T15:14:00.000-08:00

I was testing various things in sql developer and you'd think I'd know what's in there but not so. As most people know sql developer uses swing for the UI. Swing components allow you to render the content as html. This is really easy for example a JLabel.setLabel('hi') will bold the text hi. The limitation is it's html 3.2 in java 1.5. So I tried this: select ''||dummy