The Oracle database has a table user_source, can pass
Select * from user_source
Query all the stored procedure, function, view code,
This does not make any query processing is found out the original code (contains many are commented out code), suddenly there is a demand, recently is the need to pure code (comments) are not allowed to be contained inside a stored procedure, through this table can achieve such a demand?
I think don't want to come out, write SQL always flawed (or part of the comments did not take out, either remove the part of useful code)

I am by analyzing -/* */three string position to think, but it is flawed, and don't know how to solve the
It is better for the script

CodePudding user response:

If no such limitations in SQL, you can also leads out into text, think of another way to deal with the text?

CodePudding user response:

reference 1st floor js14982 response:

if it is not so limited in SQL, you can also leads out into text, think of another way to deal with the text?

Export to have what way

CodePudding user response:

Such as using the sed command in the shell try
Sed -i 's #/\ *. */\ * # #'/u01/filename. TXT (not sure whether the execution, and may report errors)