Archive for the ‘SQL’ Category
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″
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!***!
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 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 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
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
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
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?!***!
PL/SQL String Helper Package
LewisC’s An Expert’s Guide to Oracle Technology
I needed to update some files and that meant updating some utility functions that I haven’t looked at in a long time. I decided to share a few of them today.
One of the most important aspects of PL/SQL…
Click to continue reading “PL/SQL String Helper Package”
Read the rest of this entry »Missing Windows in Oracle SQL Developer Data Modeler
LewisC’s An Expert’s Guide to Oracle Technology
Well, I have been using Oracle’s new SQL Developer Data Modeler (OSDM) for a couple of months now. I’ve upgraded to beta 2. I have to say I really like it. I have given some feed back and the response …
Click to continue reading “Missing Windows in Oracle SQL Developer Data Modeler”
Read the rest of this entry »SQL DML Ebook Available, Free Online
LewisC’s An Expert’s Guide to Oracle Technology
Ok, I figured out how I am going to do this. I am making my book available three ways: print, ebook and html.
For print, you can get it on amazon or through my e-store. It’s $14.95
For ebook, you can g…
Click to continue reading “SQL DML Ebook Available, Free Online”
Read the rest of this entry »Learn SQL – The Guide to DML
LewisC’s An Expert’s Guide to Oracle Technology
My SQL book is now available for print. You can see it on my CreateSpace e-store. The book is SQL DML – SQL Starter Series Book 1. This is a book for beginners. It takes someone step by step through TC…
Click to continue reading “Learn SQL – The Guide to DML”
Read the rest of this entry »


