Questions tagged [parse]
The parse tag has no usage guidance.
40
questions
2
votes
2
answers
126
views
Using TRY_PARSE in SQL Server 2008
I have a script in SQL Server 2012 like this:
Declare @ParamSPKDateFrom varchar(50), @SPKDateFrom date,
Select @SPKDateFrom = TRY_PARSE(@ParamSPKDateFrom AS date USING 'id-ID')
Can I convert this ...
0
votes
2
answers
541
views
Extract/parse info between delimiters
I have a column where there are 10 "fields" separated by the pipe character, looks like this:
texthere | somemoretext | sometinghere | moreinfo | evenmorehere | etc |
etc |
I've been ...
0
votes
0
answers
43
views
Saving JSON files in SSMS renders them unparsable?
I have some query that outputs a JSON, i.e.,
select 1 AS 'test'
for json path, without_array_wrapper
After clicking on the result, which is {'test':1}, SSMS 18.10 opens a file with the JSON output. ...
- 251
1
vote
0
answers
231
views
Scalar function parses and runs in SSMS, incorrect syntax in ScriptDOM
I'm preparing the Database migration from compatibility level 140 (SQL Server 2017) to level 150 (SQL Server 2019).
As part of the preparation, Data Migration Assistant (DMA) has been run and it found ...
- 3,500
0
votes
3
answers
11k
views
Oracle alertlog with WARNING: too many parse errors
The SQLID is not available. Any ideas on how to find the source of the problem?
9913 WARNING: too many parse errors, count=414884 SQL hash=0x896ff002
9914 PARSE ERROR: ospid=24108, error=6550 for ...
- 938
1
vote
0
answers
45
views
Parsing calculated members to StrToMember() function
The 1st 9 calculated members in my script below define start and end date strings (e.g. 'StartDateStr' and 'EndDateStr'), that I then parse into a StrToMember() function within my SELECT command, but ...
- 11
1
vote
1
answer
1k
views
Comma separated value string and compare against other values
Hey all I have been trying to wrap my head around how to go about doing this for a while now and I'm not really coming up with anything.
Here is my query:
DECLARE @ATID AS VARCHAR(3) = 12
DECLARE @...
- 115
1
vote
1
answer
194
views
I am counfused about when Oracle database won't do parsing
I am confused about when Oracle database won't do parsing?
In the AWR report, there is a metrics called "execute to parse", which means more SQL just execute without parsing when it ...
- 11
0
votes
1
answer
194
views
How can I measure the impact of queries with errors being rejected by SQL Server?
After configuring XE on November 23, 2020 to capture some errors I could count 2,163,665 occurrences of the same error coming from requests of a legacy app (that probably won’t be corrected so soon). ...
- 4,964
0
votes
1
answer
2k
views
Oracle 12cR2 / ORA-04031 - Unable to allocate xx bytes of shared memory (Shared Pool) (Hard Parse & Parallel Queries)
Sometimes I'm getting ORA-04031 error on my DWH database. The last one like this:
"ORA-04031: unable to allocate 56 bytes of shared memory ("shared
pool", "unknown object", &...
- 29
0
votes
1
answer
47
views
Why are CASE-expressions in the list documenting operator precedence?
In the list here:
https://mariadb.com/kb/en/operator-precedence/
case-expressions are put at the same precedence level as BETWEEN, between the NOT operator and the comparison operators.
However, case-...
- 279
0
votes
2
answers
59
views
Convert Text Column Web Service Data to Columns
I have a database table which stores web transactions for a fundraising donation page. One of the columns in the table stores a bunch of concatenated data in the format 'data1=value1 data2=value2 ...
1
vote
1
answer
203
views
Parsing URL Links
I have a large data set of over 10k+ rows and I'm trying to parse the url link
that people of clicked on
here is a table: dbo.email_list
UserID Cliked_Linked
101012 https:// amz/...
- 39
0
votes
2
answers
1k
views
SQL SERVER: How to get the stored procedure text EXCLUDING comments?
I need to find all the stored procs that use Transactions, as I want to enable transaction abort to those procedures. However, --I didn't do this; it's inherited-- many of the stored procedures ...
- 103
1
vote
1
answer
380
views
Oracle 12.2 shows high parse per execution ratio for unknown lob$ query
In an AWR report I see the following (most liekly recursive) query which happens very often and is parsed each time:
select obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1
The ...
- 1,446
1
vote
1
answer
35
views
pgsql Return Partial Text Field Ending In A Whole Word
I found this PHP code that returns a sub-string ending with a whole word (IE separated by a space):
if ( strlen( $body ) < $maxlength ) return $body;
$body = substr( $body , 0 , $maxlength );
$...
- 165
1
vote
1
answer
708
views
Filtering out duplicate domains from URL column using Postgres full-text search parsers
I have a PostgreSQL database containing pages and links downloaded by a web crawler, with the following tables:
pages
----------
id: Integer (primary key)
url: String (unique)
title:...
- 359
1
vote
0
answers
1k
views
How do I parse Address into Street Number, Street Name, Type, Unit Number?
How do I parse Address into Street Number, Name, Type, Unit Number? Is there a function which will conduct this?
2280 MEYERS AVE
ALDERGROVE AVE & S ...
user173948
0
votes
1
answer
211
views
SQL Server 2017 - Extracting source and target column names within a string containing column mappings
I have the following format string stored in text (could be any number of columns):
col1_source|col1_target;col2_source|col2_target;col3_source|col3_target;...
I'm trying to come up with an ...
- 13
-2
votes
2
answers
349
views
How to convert a multi-row result set into a single-row text separated by commas
I'm using this query
select Name, valueType from mytable where ID = 1
and getting this table:
But I need to covert the result set into something like:
'idGasto int, noTicket string, fechaFact ...
0
votes
2
answers
2k
views
MySQL .frm file format: how to extract column info?
Is there a more up-to-date specification for MySQL's .frm files than the one on dev.mysql.com? I'm trying to parse it manually (don't ask... just experimenting; not trying to recover anything).
The ...
- 417
1
vote
0
answers
3k
views
MySQL: query to extract text from HTML tags of a column
I have HTML tags in a column, which are used to define multi-language content on a webserver.
I need to do a query to extract several data from the database (MySQL v5.5) directly. Using stored ...
- 157
2
votes
2
answers
12k
views
Extract data from an xml fragment
In SQL Server 2014, I have the following xml fragment :
<salesorder>
<ordnum>123</ordnum>
<orddate>2017-04-17</orddate>
<details>
<detail>
...
- 23
2
votes
0
answers
473
views
Create PostgreSQL fulltext Parser
I want to make a FTS on my text column on Postgres, the problem is that I want to search words with "_" between letters, like "the_event" but the default parser split those words and identify "_" like ...
- 173
4
votes
1
answer
9k
views
xml parse in postgresSQL
I have a problem with parse simple xml:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data-set>
<department>
<ID>1</ID>
&...
- 103
1
vote
2
answers
165
views
Why is table opened every time a query is executed against it?
I execute this SQL command twice and profile
select * from sbtest.sbtest2 limit 100;
The first time profile result is
mysql> show profile for query 1;
+----------------------+----------+
| ...
- 321
1
vote
2
answers
67
views
How to make a line/string to multiple records
So, I want to create a teacher-degree (1:m) table. I have this example:
One professor has 3 degrees.
This is the actual string I have(multiple of these actually):
B.A, 1983, University of China; ...
- 13
2
votes
0
answers
838
views
What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?
I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html
What is ...
- 121
0
votes
1
answer
1k
views
Load data - fields terminated by character appearing within a field statement
I have an issue with loading data from a csv file. The question is, without preprocessing, is it possible to have an exception in the following code
load data local infile 'Program.csv' into table ...
1
vote
1
answer
2k
views
Can I parse a text value from a specific column in a query (MySQL)?
I was playing around with Sakila and I ran across the actor_info view and one of its columns is film_info which is a detail of all the movies one actor has worked in. For example a query would be:
...
- 159
-2
votes
1
answer
99
views
What is the ideal backend for global apps? [closed]
Should our tiny team use Parse or firebase or other backend solution for a global instagram-like app we are developing ?
Speed of development is very key.
1
vote
1
answer
326
views
How to store likes to posts in Parse.com database?
In my parse database I have a classed called Post and Like. Should I create a field likes in Post class with Relation<Like> type or there is another better option of storing likes in Parse DB?
- 111
4
votes
2
answers
2k
views
SQL Server Management Studio: how to parse stored procedure code and check if table columns exist?
I'm afraid that SSMS won't parse table columns within a stored procedure.
When you click in Parse option
SSMS says that parse is completed, even when a procedure is selecting a column that does not ...
- 337
0
votes
0
answers
2k
views
Oracle 11.2 Explain Plan takes too long
I'm using Oracle 11.2 SE on a 16GB Xeon E3 Linux machine as well as 11.2 XE on a 8GB i7 Win8 machine:
SELECT banner FROM v$version:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL ...
- 151
1
vote
1
answer
79
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 ...
- 43
2
votes
1
answer
1k
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,060
3
votes
1
answer
2k
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, ...
- 31
25
votes
1
answer
24k
views
How to preserve the original order of 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 and ...
- 10.6k
2
votes
3
answers
216
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 <...
user843
6
votes
1
answer
2k
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,723