Latest Publications

Building a PL/SQL Code Parser (using PL/SQL), Part 2

DBAs and Developers, Do you suffer from Performance Dysfunction (PD)?

Group By Grouping Sets

Twitter Weekly Updates for 2009-02-08

3 Cloud Operating Systems You Can Use Right Now http://tinyurl.com/c52puq #
Blogged “Building a PL/SQL Parser (using PL/SQL), Part 1″ http://it.toolbox.com/trd/46/2/29703/3/ #
Blogged “I apologize for the state of the code formatting” http://it.toolbox.com/trd/46/2/29705/3/ #
@wfavero the first time it is annoying, the second frustrating but after a handful of times, they need to start testing better. in reply [...]

Click to continue reading “Twitter Weekly Updates for 2009-02-08″

Building a PL/SQL Code Parser (using PL/SQL), Part 1

Twitter Weekly Updates for 2009-02-01

@bananakin why no laptop? #
New podcast; Aptana Cloud ?http://tinyurl.com/b3yg4l #
RT @Database_News DB2 Storage Engine for MySQL Coming Soon – System iNetwork: DB2 Storage Engine for MySQL Coming. http://tinyurl.com/c3qena #
Sprint laying off 8000 by march http://tinyurl.com/d484yq #
@bananakin I guess you got an apple with a wyrm in it. #
Home depot laying off 7000, caterpiller [...]

Click to continue reading “Twitter Weekly Updates for 2009-02-01″

3 Cloud Operating Systems You Can Use Right Now

Have you taken the leap into the cloud? If you don’t want to start with data centers in the sky, you can start with a desktop in the sky. Microsoft has offered Live Mesh for a while now. I wrote about live mesh on this blog. Live Mesh, even though it offers a desktop, is [...]

Click to continue reading “3 Cloud Operating Systems You Can Use Right Now”

I apologize for the state of the code formatting

This is very frustrating to me. Apparently a change was made here at ittoolbox that is screwing up the HTML PRE tag. Posts that used to look good now look like crap. If I allow line breaks, it is somewhat readable but doesn’t keep spacing. If I don’t allow line breaks, which I usually don’t, it is pretty unreadable.

I’m not sure how long this has been going on. I posted a new entry a little while ago and thought something was wrong with my new post. However, after wasting part of my sun

Click to continue reading “I apologize for the state of the code formatting”

Building a PL/SQL Code Parser (using PL/SQL), Part 1

LewisC’s An Expert’s Guide to Oracle Technology
Is it possible to build a PL/SQL parser using nothing but PL/SQL? To answer that question, I guess I need to define “PL/SQL parser”. What would be the intention of this parser?
I would like a way to pa…

Click to continue reading “Building a PL/SQL Code Parser (using PL/SQL), Part 1″

Aptana Cloud Podcast

I recently had the opportunity to spend some time on the phone with Kevin Hakman, the Director of Evangelism at Aptana.  Aptana makes the popular open source web development IDE, Aptana Studio and offers a cloud service for moving your web applications out to the cloud.
We had a great discussion where we talked about Aptana [...]

Click to continue reading “Aptana Cloud Podcast”

Does SCRUM mean no more documentation?

LewisC’s An Expert’s Guide to Oracle Technology
I have embarked on a new adventure. I am sailing the waters of agile development, specifically scrum. Scrum is not an acronym. It comes from the rugby term.
My new environment is a fairly mature scrum …

Click to continue reading “Does SCRUM mean no more documentation?”

Comment by vijay on What is the difference between Oracle, SQL and PL/SQL?

thnx

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/what-is-the-difference-between-oracle-sql-and-plsql-9602!***!

Click to continue reading “Comment by vijay on What is the difference between Oracle, SQL and PL/SQL?”

Twitter Weekly Updates for 2009-01-25

@peglegpug Yeah, I left after the imax dome. I’ve been fighting a cold and was in bed by 9:30. Sounds like a good times was had though. in reply to peglegpug #
@mositampa How do I contact you about the Mosi Ambassador and the Jan 21 show? I’d like to be involved in [...]

Click to continue reading “Twitter Weekly Updates for 2009-01-25″

Job Available: BI Architect/ETL Develope

LewisC’s An Expert’s Guide To Oracle Technology
Here is another very cool looking job. Looks like the mid-west is hopping. Plenty of database (especially architect) type openings.
Location: Indianapolis/Plainfield, IN
Employment Type: Direct/Permane…

Click to continue reading “Job Available: BI Architect/ETL Develope”

Comment by prajit on Learn Oracle – What is Oracle?

First of all, I would like to thank you for sharing this helpful article. I am doing my BSc Computer science(second year). I wanted to know more about oracle.I am thinking of getting a certificate in Oracle course; But I’m confused in which category? I would be happy if you would suggest me something! As i will be learning SQL and database in my third year, so I think it would boost my carrier too. If I’m wrong then pls correct me.

Thank you,

Prajit Nair.

!***! Entry Link:http://it.t

Click to continue reading “Comment by prajit on Learn Oracle – What is Oracle?”

Comment by SUMIT on State of the Database 2008: Vertica, Part 1

One most important questions….

whats the vertica database License cost??

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/state-of-the-database-2008-vertica-part-1-26171!***!

Click to continue reading “Comment by SUMIT on State of the Database 2008: Vertica, Part 1″

Comment by Bob on Manually creating a Logical Change Record (LCR)

That was excellent!

I was having a little trouble when I was setting p_table_owner to a schema other than my own (I even have DBA and the select on all_tab_columns was successful).

Statement:

v_lcr.set_value(‘new’, ‘first_name’…

was throwing that ‘first_name’ did not exist in the LCR.

Once I copied the table to my own schema, works great!

Good for now – exactly what I needed – trying to develop the DML_Handlers before Streams is up and running.

Click to continue reading “Comment by Bob on Manually creating a Logical Change Record (LCR)”

Comment by Bob on Manually creating a Logical Change Record (LCR)

That was excellent!

I was having a little trouble when I was setting p_table_owner to a schema other than my own (I even have DBA and the select on all_tab_columns was successful).

Statement:

v_lcr.set_value(‘new’, ‘first_name’…

was throwing that ‘first_name’ did not exist in the LCR.

Once I copied the table to my own schema, works great!

Good for now – exactly what I needed – trying to develop the DML_Handlers before Streams is up and running.

Click to continue reading “Comment by Bob on Manually creating a Logical Change Record (LCR)”

Comment by abdullah ali on Learn PL/SQL: Procedures and Functions

Hello, I tried to answer, but I could not

first:

Write PL/SQL function to find the employee details .function must pass empid as a parameter?

second:

Write a PL/SQL Procedure to update the employee information by using employee ID?

thank you

!***! Entry Link: Learn PL/SQL: Procedures and Functions!***!

Click to continue reading “Comment by abdullah ali on Learn PL/SQL: Procedures and Functions”

Cisco Unified Computing

So Cisco has decided to enter the server market. They talk about unified computing, i.e. Unified compute management. They want to be the company that provides the oversight of data, network and compute power in your network.
I really thought we would be talking about vmware in that role by now.
I’m not sure that cisco has [...]

Click to continue reading “Cisco Unified Computing”

Comment by Zeta on Cloud Computing Defined

Security is a bit of an issue, but there are also loads of potential benefits of cloud computing, have a read of our blog post: http://www.zeta.net/blog/2009/01/what-cloud-computing-means-for-you/

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/cloud-computing-defined-28433!***!

Click to continue reading “Comment by Zeta on Cloud Computing Defined”

Comment by “ishan kumar” on Learn Oracle – What is Oracle?

sir,

I am a second year engineering student with IT branch.

I want to learn oracle upto the best level.Kndly guide me,like how should i start and provide me some good notes.

thankyou sir

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by “ishan kumar” on Learn Oracle – What is Oracle?”

Comment by ting zhang on Oracle Modernization Solutions

Thank you very much for sharing the information of the book,in fact i was depressed by SOA..when boss told me that the new project needed SOA,in my mind,there is a big question…why ?what and how? boss said to me,you must designed it,and big questions appeared…but i cant say that boss,i dont know how to do it and why it is needed… so i searched much information about SOA,in fact,this is not a software or ide,just a thought… later i went to a meeting about SOA,and learned something

1.w

Click to continue reading “Comment by ting zhang on Oracle Modernization Solutions”

Comment by ting zhang on Top 10 Tips For a DBA

hehe,it is very interesting,i am a coder and i found it is also for developers..

1.Sit around writing or reading the blogs until the users found an application Lack of functions. Don’t add a function until someone besides you notice.

2.Ask for all permissions from DBA even you dont need it.

When a DBA asks you a question,just tell him the application needs.

3.Explain to users and management that performance issues are always caused by network or database.

4.

Click to continue reading “Comment by ting zhang on Top 10 Tips For a DBA”

Oracle Modernization Solutions

Oracle Modernization Solutions
A practical guide to planning and implementing SOA integration and Re-architecting to an Oracle platform
Authors: Tom Laszewski, Jason Williamson

Co-Authors: Mark Rakhmilevich, Michael Oara, Prakash Nauduri

Publisher…

Click to continue reading “Oracle Modernization Solutions”

Comment by gill on Top 10 Tips For a DBA

thank you,i got it.

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/top-10-tips-for-a-dba-28310!***!

Click to continue reading “Comment by gill on Top 10 Tips For a DBA”

Twitter Weekly Updates for 2009-01-18

Windows 7 boots and shuts down much faster than vista. #
Netflix watch now works great in win7, too. I was afraid it might not. #
I’ve lost my back and forward buttons in firefox though. Not sure what’s up with that. #
@fuadar it’s cold here in florida too. It was low 40s today. [...]

Click to continue reading “Twitter Weekly Updates for 2009-01-18″

Help Wanted – Oracle Streams in Mexico

LewisC’s An Expert’s Guide to Oracle Technology
For those of you who know Oracle Streams and might be looking for something a bit different, try a short term job in Mexico. AltiusPAR Solutions is looking for help with an Oracle Streams Replication I…

Click to continue reading “Help Wanted – Oracle Streams in Mexico”

Comment by yoyo game on Learn Oracle: The Index

wow power leveling Grinding Guide

Some people consider grinding the fastest way to level in the wow power leveling, grinders will choose wow powerleveling a zone where the mobs are close to their world of warcraft power leveling (maybe a little higher) and they will just kill and <A href=”http://www.wow-p

Click to continue reading “Comment by yoyo game on Learn Oracle: The Index”

Comment by tommer weingarten on Introduction to Basic SQL, Part 1

thank you. i’ve installed it and i have SQL command line but in your article above it says i should have SQL plus, how would i install that

? or does it come with the link that u told me to insall?

!***! Entry Link: Introduction to Basic SQL, Part 1!***!

Click to continue reading “Comment by tommer weingarten on Introduction to Basic SQL, Part 1″

 
WordPress Loves AJAX