Revision history [back]

SQL/PLSQL blocks can be stripped of their comments by using regular expressions in a text editor or a scripting language. Here is an example of how to do it using Python:

import re

# SQL/PLSQL block with comments
block = '''
/*
This is a comment
*/
SELECT * FROM customers; -- This is another comment
'''

# Regular expression to match comments
comment_pattern = r'(--.*)|(/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+/)'

# Remove comments using regular expression substitution
block_without_comments = re.sub(comment_pattern, '', block)

print(block_without_comments) # Output: SELECT * FROM customers;

The regular expression comment_pattern matches both single-line comments (starting with --) and multi-line comments (starting with /* and ending with */). The re.sub function replaces all matches with an empty string, effectively removing the comments from the SQL/PLSQL block.