Skip to main content
188 questions
Newest Active Bountied Unanswered
-2 votes
2 answers
120 views

Basically I have the following statement (that works) ... SELECT * FROM `my_table` WHERE `my_field` REGEXP '[\[|,]24[\]|,]'; My string data is ... [24,1,2] => FOUND [1,24,2] => FOUND [1,2,24] =&...
Bernhard's user avatar
  • 185
2 votes
2 answers
145 views

I want my regular expression should error out if my string contains any character other than Alphanumeric. The string should error out if there is a new line character or any white space character in ...
Devashri B.'s user avatar
  • 2,789
1 vote
1 answer
52 views

I am trying to use regexp_like to search for an SSN pattern of 123-45-6789 OR XXXXXXXXX , I tried this but this is not working in Snowflake, this works in Oracle. select * from customers where ...
Himanshu Kandpal's user avatar
  • 1,676
0 votes
1 answer
39 views

I was looking for a way to validate US ZIP codes and got an answer here. I tested it using regex101 site and confirmed. However, when I use the same expression in an Oracle stored procedure and pass ...
NoBullMan's user avatar
  • 2,252
0 votes
1 answer
175 views

I have a requirement where I need to identify if a string has any special/junk characters excluding Arabic and alphanumeric and space. I have tried below, but its not detecting spl character select ...
Abdul Nizar's user avatar
  • 3
2 votes
2 answers
2k views

I am trying to run a query in Oracle 11g where I am looking in a VARCHAR column for any rows that contain any of a carriage return, new line or tab. So far my code is as shown select c1 from ...
rodneyc8063's user avatar
  • 123
0 votes
1 answer
458 views

I need to make some changes in SQL within a CURSOR. Previously, the maximum value for column 'code' was 4 characters (e.g. K100, K101,....K999) but now it needs to be 8 characters (e.g. K1000, K1001, ...
Amish's user avatar
  • 3
0 votes
1 answer
531 views

I am using the following query to select valid email address from DB2 database. Select CM_ID, CM_EMAIL from table_info where REGEXP_LIKE (CM_EMAIL,'^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}...
Md. Abdul Hannan's user avatar
  • 3
0 votes
1 answer
187 views

as part of a PL/SQL script, we are setting a Varchar variable called 'V_COMMENT' as such: V_COMMENT := INCOMING_COMMENT || '[' || V_COMMENT || ']'; because this statement is run potentially multiple ...
Austin's user avatar
  • 18
0 votes
1 answer
37 views

I have a datas in my Oracle DB that look like these : 2015-2265-0201 (dddd-dddd-dddd) in a column called "cote". However, through a bad manipulation, some of these look like these : ...
LoicJu's user avatar
  • 21
0 votes
2 answers
419 views

I am working with an programm which uploads emailadresses to another programm - but it accepts emails only in one way: i tried to write a reglular expression to filter out emailadresse which are not ...
Tobias G.'s user avatar
  • 7
-1 votes
2 answers
70 views

Question- select all city from station table where start and end letter of city must be any vowel (a/e/i/o/u). The solution which I through: `` SELECT city FROM station WHERE REGEXP_LIKE (city, '^(a|e|...
Dhirendra Singh Bisht's user avatar
  • 17
0 votes
1 answer
445 views

I'm learning about regular expressions. This expression doesn't work in PLSQL: ^[A-Z0-9 \-]{4,12}$ I'm using it this way: IF C_INFO.ID IS NOT NULL AND REGEXP_LIKE(C_INFO.ID,'^[A-Z0-9 \-]{4,12}$') ...
E.G.'s user avatar
  • 3
-4 votes
1 answer
315 views

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described as follows: station table ...
shashikant solanki's user avatar
  • 1
0 votes
2 answers
337 views

I have a table with a column that contains mobile numbers, this table has about 40 millions records. this is the table schema with some dumping data query -- phpMyAdmin SQL Dump -- version 4.9.7 -- ...
ahmed shaheen's user avatar
  • 11

15 30 50 per page
1
2 3 4 5
…
13