Question: PLease help me~ This is a reverse example: Up to module 18 we had object of type table or view and run a query to

PLease help me~

This is a reverse example:

Up to module 18 we had object of type table or view and run a query to generate a report.

Now your assignment is (Final assignment)

Create table Bonus and do DML insert to Bonus table for the following script:

Hint: you should be able to ran this script against your table without any error and generate the output "Here is the result".

PLease help me~ This is a reverse example: Up to module 18

Create table Bonus and do DMT insert to Bonus table for the following script: Hint: you should be able to ran this script against your table without any error and generate the output "Here is the result" SQL> select (substr ?Help video (substr (substr (1.object, instr (1.object,',)+1 instr(substr (1.object, instr(1.object, ', ')+1),',)+1), instr (substr (substr (1.object,instr (1.object,',)+1), instr (substr (l.object,instr (l.object, ',')+1) ,')+1)+1)) ref from Bonus l where 1.1 index = 't234' Here is the output: REF Create table Bonus and do DMT insert to Bonus table for the following script: Hint: you should be able to ran this script against your table without any error and generate the output "Here is the result" SQL> select (substr ?Help video (substr (substr (1.object, instr (1.object,',)+1 instr(substr (1.object, instr(1.object, ', ')+1),',)+1), instr (substr (substr (1.object,instr (1.object,',)+1), instr (substr (l.object,instr (l.object, ',')+1) ,')+1)+1)) ref from Bonus l where 1.1 index = 't234' Here is the output: REF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!