Oracle PL/SQL

[Agamemnus]

******like indentations in code?******

SQL is good, but only when you don't torture students with... intricacies.

<<tortured student.

[Ninkazu]

People who hate indentions are queer.

(I was using netbeans for my code, so it was putting 8 spaces in instead of a tab... so ya, I can see why you're pissed.)

[heavenraiza]

< --- likes PL/SQL.

i started this post bc i needed help writing an anonymous block but i figured it out. i couldnt do it last night. i guess i was too fatigued & plus i was drinking. =\

Aga%, alot of people feel the same way when it comes to SQL, tortured. when i took my first course all people did was complain & they refused to excel in the language.

[toonski84]

I dont understand... How is PL/SQL different from SQL? By SQL, I mean:

Code:

See below.

All of that.. How does PL/SQL differ except that it's for Oracle databases only?

[heavenraiza]

very small differences:

Code:

SELECT column(s) FROM table(s) WHERE condition ORDER BY column(s);
INSERT INTO table VALUES (definitions) WHERE condition;
DELETE column(s) FROM table WHERE conditions;

LIMIT is not a PL/SQL reserved word. if it is i havent come across it yet. . .

[toonski84]

Actually, that's proper SQL syntax. I made some mistakes, and you can use multiple columns with commands as well.

Then yeah, SQL is great. I really see no difference between them.

[heavenraiza]

yea, i like SQL. people still say there are small differences. even though the code above is a simple, maybe as the coding gets more complicated, the differences will appear. i'll havta check on that.

[Neo]

Perhaps they're different in HAVING, GROUP BY, ASC, DESC, and other functions like COUNT(*), MAX(*), MIN(*), AVG(*), etc.

[ak00ma]

Perhaps they're different in HAVING, GROUP BY, ASC, DESC, and other functions like COUNT(*), MAX(*), MIN(*), AVG(*), etc.

Yeah, i think so, too. But in the basic all those dialects are the same

You can compare it with Basic...there are QBasic, GWBasic, PowerBasic. They are all based on Basic, but have some little (or less little) differences.

[heavenraiza]

right.