Skip to content
Advertisement

Tag: find

Find position of first number in string and split

I am attempting to find the first numeric character in an ID composed of a client segment identifier (ABC_), a geographic identifier (UK) and a number (1234567). The ID will without exception follow this logic: ABC_UK1234567 From this, I need to extract the number only (the location identifier will have different lengths, as it could be ABC_UK, ABC_CHR or ABC_I

Find Stored Procedure By Table Name (Oracle)

Need help. Every morning at 4 o’clock a table is created in the database, I need to understand what sources are used to create it, so I tried to find a stored procedure that creates this table using all_source or dba_source (select * from all_source where upper(text) like ‘%TABLE_NAME%’, but the result was returned empty. I think this has to

Rails Query with ILIKE

I have written a finder as follows: params[:manufacturer] comes through in a form of a string that has been .parameterized by Rails. The problem is that a string with an “‘” or an “&” in it doesn’t get matched by ILIKE correctly. So as an example, some strings that are stored in my DB and their parameterized versions: “This is

Advertisement