Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

SQL*Plus

SQL*Plus is the client software for Oracle that runs SQL statements and anonymous block PL/SQL statements in an interactive and batch development environment. They’re organized in the order that you generally encounter them as you start working with SQL*Plus or the MySQL Monitor.

Although Oracle supports large object types, you couldn’t display more than 32,767 characters’ worth of them in SQL*Plus prior to Oracle Database 10g. That’s because the maximum size of a long data type was 32,767, and SQL*Plus displayed large objects using the LONG data type. From Oracle Database 10g forward, you can set the LONG environment variable as high as you want, and it works. The CLOB data type is displayed now by SQL*Plus, but the LONG environment variable hasn’t changed yet. Likewise, you can see a billion bytes of a binary large object in SQL*Plus.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint