Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a RegX expression to capture these expressions: - REPLACE/INSERT should be Group1 - table name (first word after TABLE) should be Group1 - list

Write a RegX expression to capture these expressions:

- REPLACE/INSERT should be Group1

- table name (first word after TABLE) should be Group1

- list in first set of parenthesis should be Group3

- list in second set of parenthesis should be Group4

image text in transcribed

Group4 should be what is circled below (excluding the parenthesis):

image text in transcribed

Group3 should be what is circled below (excluding the parenthesis):

image text in transcribed

You can use the equation I have made so far, just wondering how to capture the commas and how to repeat it over until it identifies the ending parenthesis symbol ( ")" ).

e regex101 0 $ 1 III REGULAR EXPRESSION 3 matches, 415 steps (~1ms) / gmi 1 / ([a-za-z] \w*) \s+TABLE\s+\s* ([a-za-z] \w*) \s*\((?:([a-za- z] \w*\, \s+)) TEST STRING SWITCH TO UNIT TESTS INSERT TABLE table_2 (ps, b, fx) VALUES ("hello", 4, true) REPLACE TABLE tablem (ksy, g) VALUES (false, "fog") INSERT TABLE table06 (dghs, hgf, nm) VALUES (65, true, "cat") = regexio y $ 4. DI REGULAR EXPRESSION 3 matches, 415 steps (~1ms) /gmi 1/([a-za-z] \w*) \s+TABLE\s+\s* ([a-za-z]\w*) \s* ((?: ([a-za- z]\w*\, \s+)) TEST STRING SWITCH TO UNIT TESTS INSERT TABLE table_2 (ps, b, fx) VALUES "hello", 4, true) REPLACE TABLE tablem (ksy, g) VALUES ((false, "fog") INSERT TABLE table06 (dghs, hgf, nm) VALUES (65, true, "cat") = regex 101 REGULAR EXPRESSION 3 matches, 415 steps (~1ms) ([a-za-z]\w* ) \s+TABLES+\s* /gmi ([a-za-z] \w*) \s* \((?: ([a-za- Z]\w*\,\s+)) TEST STRING SWITCH TO UNIT TESTS INSERT TABLE table_2 |(ps, b, fx) VALUES ("hello", 4, true) REPLACE TABLE tablem VALUES (false, "fog") INSERT TABLE table 06 |(dghs, hgf, nm) VALUES (65, true, "cat")

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899

Students also viewed these Databases questions