Posts
Oracle is the most popular client-server database system in the current market. If you have access
to an Oracle database, you can load the Lyric Music database with the following steps.
❍ Launch Oracle SQL Plus and log in using the master system user name or a login provided
to you by your database administrator.
To practice your SQL, do the following:
❍ Launch Oracle SQL Plus and login using the master system user name or a login provided to
you by your database administrator.
❍ At the SQL prompt type your SQL command. You may use multiple lines for the command
if you wish. At the end of the last line add a semi-colon (;) to execute the command.
Data description commands:
❍ To list all user tables in your Oracle database type: select table_name from user_tables;
❍ To list all fields and data types in a particular table type: describe tablename;
Refs:
A Brief History http://www.vbip.com/books/1861001800/chapter_1800_02.asp
of SQL
The Rise of http://www.nap.edu/readingroom/books/far/ch6.html
Relational Databases
A Brief History http://wwwinfo.cern.ch/db/aboutdbs/history/industry.html
of Databases
MySQL http://www.mysql.com/
to an Oracle database, you can load the Lyric Music database with the following steps.
❍ Launch Oracle SQL Plus and log in using the master system user name or a login provided
to you by your database administrator.
To practice your SQL, do the following:
❍ Launch Oracle SQL Plus and login using the master system user name or a login provided to
you by your database administrator.
❍ At the SQL prompt type your SQL command. You may use multiple lines for the command
if you wish. At the end of the last line add a semi-colon (;) to execute the command.
Data description commands:
❍ To list all user tables in your Oracle database type: select table_name from user_tables;
❍ To list all fields and data types in a particular table type: describe tablename;
Refs:
A Brief History http://www.vbip.com/books/1861001800/chapter_1800_02.asp
of SQL
The Rise of http://www.nap.edu/readingroom/books/far/ch6.html
Relational Databases
A Brief History http://wwwinfo.cern.ch/db/aboutdbs/history/industry.html
of Databases
MySQL http://www.mysql.com/
0 comments:
Post a Comment