Skip to content

Instantly share code, notes, and snippets.

@midoribashikk

midoribashikk/0_grep.sql

Created June 21, 2019 14:01
Show Gist options
  • Save midoribashikk/4117df7000b03473f6a3dc83811cf19b to your computer and use it in GitHub Desktop.
Save midoribashikk/4117df7000b03473f6a3dc83811cf19b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
0_grep.sql
select name, type, line, replace(replace(text, chr(13), ''), chr(10), '') as text
from user_source
where type in ('FUNCTION', 'PROCEDURE', 'PACKAGE BODY')
and text like '%2999/12/31%'
order by name, line;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment