Well, I’ve been using SQL Developer for about three weeks now. When SQL Developer was first released a few years ago, I was not a big fan of this free tool. I’m still not a big fan at this point, but I will say that the tool is growing on me everytime I use it. What I’m finding interesting about it at this time is how it deals with RAW datatypes. When you select a RAW column from a table all you get in the column is (RAW) in the column.
Sql Script
—————-
select job_id, job_name, job_owner, job_description, job_type
from sysman.mgmt_job
where rownum < 4
Results
—————-
JOB_ID JOB_NAME JOB_OWNER JOB_DESCRIPTION JOB_TYPE
(RAW) LOAD USER_QUEUE DATATEAM SQLScript
(RAW) LOAD SDA DSUMMS DATATEAM SQLScript
(RAW) UPDATE PROCESS_TIMESTAMP DATATEAM SQLScript
As you can see if you are trying to find a job_id for one of the listed jobs it is difficult from SQL Developer. Now, from TOAD this issue is not relative; however, I’ve decided to use SQL Developer recently since I cannot get the company to purchase new TOAD licenses. What can you do when you are pretty much told that the company doesn’t like Quest due to pricing issues.
So the solution to gettting around this issue is to covert the column to hex using the RAWTOHEX() function. To do this I modified the query to allow the job_id column to displace the relative information that I was looking for.
Sql Script
—————–
select rawtohex(job_id), job_name, job_owner, job_description, job_typefrom sysman.mgmt_job
where rownum < 4
(for simplicity reason only used the first two columns)
Results
—————-
—————-
JOB_ID JOB_NAME
4883A26B1F5806A2E0400A0A4A020878 LOAD USER_QUEUE
4883A26B1F6306A2E0400A0A4A020878 LOAD SDA DSUMMS
4883A26B1F6A06A2E0400A0A4A020878 UPDATE PROCESS_TIMESTAMP
Hope this helps.
Another good post for issues with RAW datatypes and PL/SQL see http://thinkoracle.blogspot.com/2005/11/raw-datatype.html
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
I blog frequently and I seriously thank you for your information. This article has truly
peaked my interest. I am going to bookmark your blog and keep checking
for new details about once a week. I subscribed to your Feed too.
Here is my blog post … vpn
cbd for pets are a convenient and enjoyable means to pocket cannabidiol without the high. Diverse people use them to affluence worry, improve rest, or promote inclusive wellness. The effects mainly originate within 30–60 minutes and can pattern as far as something sundry hours. You’ll find options with melatonin, vitamins, vegan ingredients, or no added sugar. They loosely transpire b emerge in a row of flavors and strengths. It’s most suitable to start with a unrefined dose and always contain as regards third-party lab testing to ensure trait and safety.
I was very pleased to discover this site.
I want to to thank you for your time for this particularly fantastic read!!
I definitely loved every little bit of it and i also have
you bookmarked to see new information in your blog. gamefly https://tinyurl.com/28wjzmw4
Howdy just wanted to give you a quick heads
up. The words in your post seem to be running off the screen in Ie.
I’m not sure if this is a format issue or something to do
with web browser compatibility but I figured I’d
post to let you know. The layout look great though!
Hope you get the problem resolved soon. Kudos vpn meaning https://tinyurl.com/2c2rno87
Hi to every single one, it’s in fact a pleasant for me to pay
a visit this web site, it contains helpful Information.
With havin so much written content do you ever run into any problems of plagorism or copyright infringement?
My blog has a lot of unique content I’ve either authored myself or outsourced but it seems a lot of it is popping it up all over the internet without my permission. Do you know any methods to help stop content from being stolen? I’d truly appreciate it.