Acrobat X Files

Home > Programming > Oracle Programming

Database Programming in SQL/Oracle

Sort Desciption:

correct i.e. must be executable as an SQL query or program ... since /home/dbis/dbprakt/MondialDB/oracle contains the scripts for generating the ...

Content Inside:

Database Programming in SQL/OraclePage 1Introduction to OracleWolfgang Maymay@informatik.unifreiburg.deInstitute for Computer ScienceUniversity FreiburgOctober 20041 General1.1 Administrative stuffThe training is carried out in groups of three until four students each. The participants log on toOracle via their own UNIX accounts. Thus in addition to the UNIX account for accessing theinstitutes workstations also an Oracle account is required to connect to the database. Eachparticipant has an ownOracleAccount.GroupdirectoryFor each group there exists an additional directory /home/dbis/dbprakt/grpn where all groupmembers (and the supervisors) are allowed to read and write. There SQLscripts of the groupshould be placed.Communication with the supervisors is done by the mailing list sqluser : supervisors and participantsSlides lecture notes exercise sheets etc. can be found on the Web:http://dbis.informatik.unifreiburg.de/ index.php?course=SS06/Praktikum/Programmie rung+in+SQL/index.html1.2 Group DirectoryFor each group there is a directory at/home/dbis/dbprakt/grpxwhere x is the group number. Additionally each group is administered as a UNIX group calledoragrpx .For the supervision process you have to put the SQL scripts into the directory to make it accessiblefor the supervisor some days before the discussion. For this you should create directories sheet1sheet7 in the group directory and then put your code for the individual exercises into thedirectories as ex1.sql ex2.sql ... The code should be correct i.e. must be executable as an SQL query or program suitably indented and contains comments that make it understandable.The supervisor will have a look at your programs before the discussion (and will perhaps requireyou to enhance the code).For organizing your directory in this way you need the following UNIX commands: cd /home/dbis/dbprakt/grpx mkdir sheet1Then the directory is generated but only accessible for you. Make itusable for your group members by1Page 2Introductio ...

Source: dbis.informatik.uni-freiburg.de

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...