Archive for the ‘pl/sql’ Category

Oracle DBMS_SCHEDULER Part 2 – The API

Read the rest of this entry »

PL/JSON v0.6.2 Released

Read the rest of this entry »

PL/JSON v0.6 Released to SourceForge

Read the rest of this entry »

Use a Pipelined Function to Select Source Code Arguments

Read the rest of this entry »

Stupid Database Tricks – Shutdown the server from a stored procedure

Read the rest of this entry »

ORA_Tweet Now Does Short URLs

Read the rest of this entry »

Calculating Business Days and Business Days Between

Read the rest of this entry »

Private vs Public Global Variables

Read the rest of this entry »

Catching Up – Email, PL/JSON, Oracle Open Source, ORA_Tweet on oracle.com

Read the rest of this entry »

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

Read the rest of this entry »

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

Read the rest of this entry »

When WHEN OTHERS is Evil

Read the rest of this entry »

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

Read the rest of this entry »

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

Read the rest of this entry »

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

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 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. 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?”

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 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 of this entry »

Comment by krishna on Learn Oracle – What is Oracle?

hi sir,

I am a student. Doing my masters in software engineering.

I want to learn oracle. Can u please help me in learning. LIKE where can i get correct material or notes to learn.

thanking you sir,

Krishna Reddy.Palli

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

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

Read the rest of this entry »

Comment by LewisC on Learn PL/SQL: Procedures and Functions

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

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

Read the rest of this entry »

Comment by “raman jotshi” on Learn Oracle – What is Oracle?

thanks for yr article

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

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

Read the rest of this entry »

Comment by lin on 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!***!

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

Read the rest of this entry »

Comment by MADHU on Learn Oracle – What is Oracle?

learn dbms and sql and pl/sql

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

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

Read the rest of this entry »

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

Hi Sir,

Firsttime i am vising your site, i am very happy to c you, and happy to get more information on SQL as well as PL/SQL.

Sir, the information you have provided is more understandable, and we still hoping the same Sir, thank you.

Regards,

Vikramasimha

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

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

Read the rest of this entry »

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

suvro,

If you just want to learn database management from a Java perspective, there is no reason to learn PL/SQL. However, if you want to learn database management from an oracle perspective, you must learn pl/sql. It really depends on what you want to do, code for databases, or code for Oracle.

Even though Oracle supports java in the datavase, PL/SQL gives you so much more control that I would say it is mandantory for anyone who truly wants to be an oracle expert.

T

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

Read the rest of this entry »

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

hi Lewis,

i read your articles n it gave me a nice precise idea about oracle,sql n pl/sql.currently i’m doing my engineering n i know java well.right now i want to learn database management skills.but i have the following questions in my mind.hope u can help.

1.as java n pl/sql are so similar in nature, can i use my java knowledge through oracle for learning database management?

2.will it better than learning pl/sql in anyway?

3.n if yes then what exactly do i need to learn?
<b

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

Read the rest of this entry »

Comment by “brain rollas” on Learn Oracle – What is Oracle?

i am new to this site and i am using thgis opportunity to greet all my friends and brothers in here God bless you all. am brain rollas by name and i will like to know about this subject: ORACLE. feel free to email me with more information and explanation. Thanks and God bless.

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

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

Read the rest of this entry »

Comment by Vishakha Jain Agrawal on What is the difference between Oracle, SQL and PL/SQL?

Hello Sir,

I read your article and feedbacks.

I know the difference char, varchar and varchar2.

But be practical I understood first time with the help of Length() function.

Your explanation procedure is good and helpful.

Thanks sir

!***! Entry Link: What is the difference between Oracle, SQL and PL/SQL?!***!

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

Read the rest of this entry »

When to use Triggers (and when not to!)

Read the rest of this entry »