May 12, 2013 at 2:55 am
AndrewSQLDBA (5/11/2013)
pl-sql is different that t-sql pl is Oracle based, which is cursive based. SQL Server is set based and uses t-sql Much more advanced language than pl-sql
pl/sql is set-based as well, though it has a lot of procedural aspects (pl-SQL actually stands for procedural SQL). pl-sql is in fact a much more complete language than T-SQL (at least comparing the pl-sql I used to write 10 odd years ago). Later versions of pl/sql have object-orientated aspects, allowing declaration of classes for example
Calling one 'more advanced' than the other is a disservice to both, they are very different languages even though they're both based on the ANSI standards. pl/sql kinda resembles a cross between ANSI sql and PASCAL
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2013 at 7:28 am
Gail
Thank you for the clarification. I learned something new. I was taking my judgement from my experience years ago with PL-SQL.
Hope that you have a good day.
Andrew SQLDBA
May 22, 2013 at 4:26 am
Take backup of database and restore the same in diff machine. i guess u r referring to oracle server, you can get the same in oracle websites
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply