Transcription of Oracle/SQL Tutorial - Emory University
{{id}} {{{paragraph}}}
Oracle/SQL Tutorial1 Michael GertzDatabase and Information Systems GroupDepartment of Computer ScienceUniversity of California, Oracle/SQL Tutorial provides a detailed introduction to the SQL query language and theOracle Relational Database Management System. Further information about oracle and SQLcan be found on the web , corrections, or additions to these notes are welcome. Many thanks to ChristinaChung for comments on the previous LiteratureGeorge Koch and Kevin Loney:Oracle8 The Complete Reference(The Single Most Compre-hensive Sourcebook for oracle Server, Includes CD with electronic version of the book), 1299pages, McGraw-Hill/Osborne, Abbey and Michael Corey:Oracle8 : A Beginner s Guide [A Thorough Introductionfor First-time Users], 767 pages, McGraw-Hill/Osborne, Feuerstein, Bill Pribyl, Debby Russell:OraclePL/SQL Programming(2nd Edition),O Reilly & Associates, 1028 pages, Date and Hugh Darwen:A Guide to the SQL Standard(4th Edition), Addison-Wesley, Melton and Alan R.
Oracle o ers the following basic data types: char(n): Fixed-length character data (string), ncharacters long. The maximum size for nis 255 bytes (2000 in Oracle8). Note that a string of type char is always padded on right with blanks to full length of n. (☞can be memory consuming).
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}