Recent content by Daniel Thei

Hi whip, I get an error, if I executed in a Test-Window. It seems, that you can't execute case...end in pl/sql. Or I use the wrong Oracle-Version. My Server runs Oracle 8.1.7. Greetings Daniel

There is one work-arround: copy the script to the clipboard and then insert it into MS-Word as HTML-Format (There are some ways you can use software of Microsoft :D ). Et Voil

Hi, the line 'dbms_output.disable' disable the calls of dbms_output.put_line. If you leave it out, then it will working. You don't need also dbms_output.enable. You use enable to size the dbms_output buffer. Greetings. Daniel

Here is one more enhancement: It would be great to use wildcards (like '*' and '?' or '%' and '_') in the search-field of the help window. That would be great.

Thank you Robert for your tip. Sense of Life is just to learn :cool: !! Gr

Thanx for your reply.

Hi swakoo, First question: you can choose the returning clause which you can use with update. eg: update table set column = value returning column into :variable. For more explanation look into SQL-Reference (take a look at: http://www.oracle.com/technology/documentation/oracle8i.html). Second...

Hi, I have one question and one enhancement... First the enhancement: It would be great to have a link between the tables and appendant triggers Now the question: To generate the documentation in batch process I create an output file with a statement like this: spool output; SELECT DISTINCT...