Talk:PL/SQL: Difference between revisions
→History - Time References: new section |
|||
| Line 39: | Line 39: | ||
[[User:GrandPoohBah|GrandPoohBah]] 00:52, 31 October 2007 (UTC) |
[[User:GrandPoohBah|GrandPoohBah]] 00:52, 31 October 2007 (UTC) |
||
== need help == |
|||
i m abhishek kumar i m an orcale associate in applictaion developer trackusing oracle 9i. |
|||
at prsnt i m facing aproblem in sql query the job is like that i want to genrate a report on the basis week wies entry and the report data should be prsnt in the from of like |
|||
style_no/style_name/ week-30/w1/w2/w3/w4/w5/......../w21 total |
|||
total(week-30)/totalw1/...........totalw21 |
|||
and the week values in the rows and my need is that i want to give the next 21 values of week are taken by system dynamically when a user give the input like 200745 then it calculate the value next 21 week and the column heade can change on the particulr input. |
|||
one year contains at least 52 weeks |
|||
how sholud i resolve that probel so i want ur help |
|||
plz send me areply as soon as possible with code if possible |
|||
thnks |
|||
and kind regards |
|||
abhishek kumar |
|||
abhishekkumar_184@yahoo.co.in <small>—Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/220.227.144.40|220.227.144.40]] ([[User talk:220.227.144.40|talk]]) 12:15, 18 December 2007 (UTC)</small><!-- Template:UnsignedIP --> <!--Autosigned by SineBot--> |
|||
---- |
|||
Abhishek Kumar: |
|||
Please follow this link: ---> [[WP:NOT#HOWTO]]. In the future, please use sites like [http://www.lazydba.com/ Lazy DBA] or [http://asktom.oracle.com/ Ask Tom] instead of Wikipedia to get database assistance. [[User:Wam067|Wam067]] ([[User talk:Wam067|talk]]) 03:23, 26 March 2008 (UTC) |
|||
== History - Time References == |
== History - Time References == |
||
Revision as of 14:36, 11 October 2008
| This is the talk page for discussing improvements to the PL/SQL article. This is not a forum for general discussion of the article's subject. |
Article policies
|
| Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL |
 | Computing: Software Unassessed | ||||||||||||
| |||||||||||||
Tail recursion irrelevant here
The brief discussion of tail recursion is probably off the point and confusing to readers in database art. SQL was created as a means of specifying relational operators: project, select, join, etc. Looping and recursion are not necessary to the relational algebra, hence i.m.h.o. the discussion should skip the un-programmatic aspects of SQL and dive directly into the programmatic features of PL/SQL. --Anonymous —Preceding unsigned comment added by Wernher (talk • contribs) 19:03, October 27, 2004
- Agreed. --Anonymous 2 —Preceding unsigned comment added by 165.187.10.2 (talk • contribs) 07:41, July 19, 2006
I agree as well. I've been using PL/SQL many years and never had to (or wanted to) know about "tail recursion". What about putting in a an expanded section on procedure Exception Handling? That would be really good info IMHO. Wam067 (talk) 03:04, 26 March 2008 (UTC)
Advance or Advanced Data Type
Is it "Advance" or "Advanced" Data Type? --Ernst de Haan —Preceding unsigned comment added by Ernstdehaan (talk • contribs) 11:51, April 11, 2006
- Advanced. --Anonymous 2 —Preceding unsigned comment added by 165.187.10.2 (talk • contribs) 07:42, July 19, 2006
Ada connection
"Its syntax strongly resembles that of Ada"
Actually its syntax superficially reminds you of Ada, but everything that made Ada an interesting language has been ripped out. It could just as easily have Pascal, C or even Basic syntax, for all the relevance it has to ADA.
Interestingly enough, PL/SQL is usually implemented by interpreting a byte code. The only native PL/SQL compiler works by first translating into C.
There's also an alternative language, ProC, which is a pre-processed C that allows similar embedding of SQL. —Preceding unsigned comment added by 129.113.245.64 (talk • contribs) 19:48, April 17, 2007
ADDITION : Claiming that it was based on ADA made it an easier sell to the USA Department of Defence (DOD). (By GrandPoohBah 28-Oct-2007)
First Appearance in Database
Im confused about the first appearance of PLSQL in the database. On many web sites PLSQL is listed as being introduced in Oracle Database v6. However procedures, functions, packages and triggers were first made available in Oracle v7, not v6 ! Can someone please clarify why PLSQL is often listed as appearing in v6 ? How could PLSQL be executed in v6 ? Did you have to use OCI or SQL*Plus or some other means ?
PLSQL was included in Oracle Forms v3 around the same time frame as database v6, however it had its own PLSQL engine and did not send the PLSQL code to the database to be execute (despite Oracle marketing and sales often implying that it did)
GrandPoohBah 00:52, 31 October 2007 (UTC)
History - Time References
At present the History section uses only Oracle release numbers as a time references. I think it would be helpful to have calendar years cited as well, for those who do not measure time as against Oracle benchmarks... :)