Archive for the ‘oracle’ Category

Using Bind Variables

Read the rest!

Read the rest of this entry »

PL/JSON v0.6.2 Released

Read the rest! Read the rest of this entry »

Oracle INFORMATION_SCHEMA

Read the rest! Read the rest of this entry »

Calculating Business Days and Business Days Between

Read the rest! Read the rest of this entry »

Private vs Public Global Variables

Read the rest! Read the rest of this entry »

JSON In (and out) of Oracle – JSON Data Type

Read the rest! Read the rest of this entry »

Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API

Read the rest! Read the rest of this entry »

Oracle Data Types – 5 FAQs About Number

Read the rest! Read the rest of this entry »

Advanced Queues and Streams: A Definition in Plain English

Read the rest! Read the rest of this entry »

My Introduction

Read the rest!

Read the rest of this entry »

uCertify Oracle Certification Software Review

Read the rest! Read the rest of this entry »

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

Read the rest! Read the rest of this entry »

Group By Grouping Sets

Read the rest! Read the rest of this entry »

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

Read the rest! Read the rest of this entry »

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?”… Read the rest!

Read the rest of this entry »

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. … Read the rest!

Read the rest of this entry »

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 … Read the rest!

Read the rest of this entry »

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 … Read the rest!

Read the rest of this entry »

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”… Read the rest!

Read the rest of this entry »

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?”… Read the rest!

Read the rest of this entry »

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 … Read the rest!

Read the rest of this entry »

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”… Read the rest!

Read the rest of this entry »

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”… Read the rest!

Read the rest of this entry »

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”… Read the rest!

Read the rest of this entry »

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″… Read the rest!

Read the rest of this entry »

Comment by LewisC on Oracle Announces Layoffs

Turns out that it was less than 1% of the work force. In this economy, I think they are doing a good job keeping people employed.

Of course, that doesn’t help those who were laid off. Hopefully, they all find jobs soon.

LewisC

!***! Entry Link: Oracle Announces Layoffs!***!

Click to continue reading “Comment by LewisC on Oracle Announces Layoffs”… Read the rest!

Read the rest of this entry »

Comment by LewisC on 10 Tips For Complete Database Newbies

Thank you. Comments like that are exactly why I do this.

LewisC

!***! Entry Link: 10 Tips For Complete Database Newbies!***!

Click to continue reading “Comment by LewisC on 10 Tips For Complete Database Newbies”… Read the rest!

Read the rest of this entry »

Comment by Kalai Selvi on 10 Tips For Complete Database Newbies

Wow. I’ve been toying around the idea of learning Oracle. Have read few manuals and tried my hands on 9i. But then later I moved on to .Net and now I’m back to Oracle and am looking to improve my hands on 10g. And after going thtrough your blog, it’s kinda motivating and guiding. Nice posts. Thanks a lot Lewis.

!***! Entry Link: <a href=”http://it.toolbox.com/blogs/oracle-guide/10-tips-for-complete-database-newbies-24

Click to continue reading “Comment by Kalai Selvi on 10 … Read the rest!

Read the rest of this entry »

Comment by Noah on Oracle Announces Layoffs

Fast forward a couple of years and here we are with Oracle making another round of layoffs following a merger (BEA). There’s a lot of static about it on the web and it’s been hard to find solid info, so I posted an article that helps to sort out the fact from the rumors surrounding the oracle layoffs

!***! Entry Link: <a href=”http://it.toolbox.com/blogs/oracle-guide/orac

Click to continue reading “Comment by Noah on Oracle Announces Layoffs”… Read the rest!

Read the rest of this entry »

Comment by Noah on Oracle Announces Layoffs

Fast forward a couple of years and looks like Oracle is going through another big round of layoffs… I’ve heard anywhere from 500 to 8,000 will be cut in the next 2 months. There’s a lot of static about it on the web rt now, but here?s a post that helps to sort the facts from rumors about the Oracle layoffs

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/oracle-anno

Click to continue reading “Comment by Noah on Oracle Announces Layoffs”… Read the rest!

Read the rest of this entry »