The parse tag has no wiki summary.
6
votes
1answer
287 views
How do I preserve the order of the original elements in an unnested array?
Given the string
'I think that postgresql is nifty'
, I would like to operate on the individual words found within that string. Essentially, I have a separate from which I can get word details ...
4
votes
1answer
503 views
Using sys.diana and sys.pidl to parse PL/SQL
It seems to me that it should be possible to parse existing PL/SQL with the packages sys.diana and sys.pidl, but I have found nothing on the internet with the exception of a few scripts that seem to ...
3
votes
0answers
420 views
SSIS Script to split string into columns
I have a dataset (log file) with a number of columns; one of them is "Other-Data" below (unordered string) and need to parse the string to create the derived columns according the u value (U1, U2, U3, ...
2
votes
1answer
178 views
Parsing and binding variables for SELECT .. WHERE column IN ( .. ) queries
I'm looking to make sure that all queries in a php web application have proper use of bind variables to minimize parsing of the queries.
I'm wondering how Oracle parses queries that compares a ...
1
vote
1answer
35 views
Hard Parse on Non-Identical Statements?
Let's say I have this query :
SELECT X FROM Y
If I run it for the first time then it would do a hard parse.
After that, I run this query :
select x from y
With just a difference in alphabetical ...
1
vote
3answers
175 views
How do I normalize and transform field text algorithmically
I've got names and emails exported from one sales system that I am trying to move into my email service provider. I have to normalize the data.
The email field has data like this:
John Smith ...
0
votes
0answers
87 views
Parse Data from One Column [closed]
How do I parse data from one column to many columns with no delimiters?
I have a column with NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN, I want to parse each position as a seperate column. How would one do ...
