1, write a PL/SQL blocks, find the student id is 130014101 student's name and contact phone number, and output the student's name and telephone number,
2, write a PL/SQL blocks, query all the basic information of the class, (use a for loop to complete)

3, write a PL/SQL block, according to the student, student id or name query each student's basic information,

4, write a PL/SQL block, if the students of class 1300161 class number changed to 1500161, using the cursor to the student's student id to update, change the previous 130016101 to 150016101 and so on,

CodePudding user response:

http://www.itpub.net/thread-1348543-1-1.html

CodePudding user response:

Table structure is given, the test data

CodePudding user response:

So bad, you should do first, in asking questions