Trying to copy database from my laptop to my desktop pc

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

  • 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