I get a lot of email, and comments on blog entries, asking questions about many different topics. I am going to try to answer some of the more common questions as FAQs. Today I am starting with some NUMBER FAQs. I am specifically talking about Oracle and I am specifically talking about the NUMBER data type, not numerics in general. I’ve written about NUMBERs before.

Q: What is the difference between an INTEGER and a NUMBER.

A: INTEGER is a subtype of NUMBER. INTEGER is declared as NUMBER(38,0). That means it is a “constrained” NUMBER.

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!***!

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

Lin,

That’s a topic I have been meaning to do for quite a while. I think I may spend some time on that in the next couple of weeks.

Thanks,

LewisC

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

can you pls discuss procedure vs package?Thank you

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-plsql-procedures-and-functions-13030!***!

LewisC’s An Expert’s Guide To Oracle Technology

By request, this entry will discuss some issues surrounding DML triggers. Triggers are a nifty feature. When you need them, they are very useful. They can also make maintenance and debugging an absolute nightmare.

API vs Trigger Approaches

I am an API style programmer. I do not mean that I put all of my logic in INSERT/UPDATE/DELETE procedures for each table, although that is not a bad idea. What I mean is that I tend to write functional packages and those packages deal with DML.

As an example, let’s say I have an HR system.

LewisC’s An Expert’s Guide To Oracle Technology

I mentioned the other day that I was playing with a new GUI builder from an EnterpriseDB partner, Wavemaker. Wavemaker, in addition to providing the software, provides some training that is downloadable from the web site.

This training is a two day basics course in powerpoint format. I would guess that this is what they use for instructor led training and they just made this available to the public. Anyway, I decided to see how good the training was which in turn kind of tells me how easy wavemaker is to learn.

Day 1 includes 8 powerpoint presentations:

• Introduction
• Wavemaker Architecture
• Wavemaker Installation
• Wavemaker Studio Overview
• Page Designer Basics
• Wavemaker Data Model
• Service Components
• Data Widgets

Seeing as how I was already making some simple pages with the tool, I blew through the intro, the architecture and installation.

Bind variables are used to ease code maintenance and to save memory and processing on the server. When you save memory and processing power, you improve the overall performance of the server. The inner details of how this saves memory has been enumerated in other places on the web. This article is designed to help developers users bind variables when running queries against Postgres Plus Advanced Server.

What are bind variables?

The easiest way to think of a bind variable is to consider it just another variable. Instead of it being a variable to be used by your application (and whatever language you happen to be using), think of it as a variable to be used by SQL.

I was browsing around YouTube tonight and ran across this video of a webinar that Steve Feuerstein did back in 2005. It’s about an hour long. He covers various pl/sql tips that for the most part you should know by now unless you are just starting out. It is probably a good refresher for someone who doesn’t spend most of their time coding PL/SQL.

Some of the things he calls mistakes, I would not. Some are just preference issues. Worth watching though.

LewisC

oracle video pl/sql tips

Probably the most popular question I am asked is something along the lines of, “I just graduated college and want to learn Oracle. How can I do that?” Sometimes, it may be, “I have worked as a functional on an Oracle Applications implementation and want to learn technical.” The question that some times frightens me is, “I heard I can make a lot of money with Oracle. I want to be a DBA or developer, which ever makes more money.”

Ok. So I am going to make the assumption since you are reading this that you want to learn Oracle.

So you’ve decided to learn/evaluate/use EnterpriseDB. That’s great. The first thing you need to do is get it and install it.

Download

To get EnterpriseDB, you need to navigate over to the EnterpriseDB download page. If you haven’t already signed up for an account, you will need to get one. It’s free and, by signing up, you will also have access to the support forums.

When you sign up, you will get an EnterpriseDB Network Account ID. This ID will be emailed to the account you sign up with. SAVE THIS EMAIL!

This continues the blog began in Part 1 of A Day with Ralph Kimball.

So, on to the seminar! Please remember that this isn’t what Ralph said as much as it’s my interpretation of what Ralph said. I’m trying to explain what you’ll get from his seminar but it’s through my eyes not yours. That’s why this is not a replacement for his seminar. Hopefully, I will induce you to attend if he makes it to your town. You should go just so that you can tell me where I got it wrong if for nothing else.

When we last saw our intrepid heroes they were devouring their lunch and asking Ralph inane questions.