In this problem we are supposed to create a table and insert the given values an

Question

In this problem we are supposed to create a table and insert the given values and the result should show in query. ANY help or input is appreciated.

Question:

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".


SQL> select (substr

(substr

(substr(l.object,

instr(l.object,',')+1

),

instr(substr(l.object,

instr(l.object,',')+1),',')+1),

instr(substr(substr(l.object,instr(l.object,',')+1),

instr(substr(l.object,instr(l.object,',')+1),',')+1),',')+1)) ref

from Bonus l

where l.l_index = 't234'


Here is the output:

REF

------------------------------------------------------------

Here is the result

again any input is helpful have been working this problem all day and havent figured it out yet

Explanation / Answer

I need this too!!

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.