Questions tagged [parse]
The parse tag has no usage guidance.
33
questions
0
votes
1answer
27 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). ...
0
votes
1answer
209 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", &...
0
votes
1answer
30 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-...
0
votes
2answers
40 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
1answer
53 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/...
0
votes
2answers
476 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 ...
1
vote
0answers
99 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
vote
1answer
18 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 );
$...
0
votes
1answer
416 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:...
1
vote
0answers
518 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 ...
0
votes
1answer
86 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 ...
-2
votes
2answers
100 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
2answers
1k 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 ...
1
vote
0answers
2k 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 ...
0
votes
0answers
41 views
Statements vs PreparedStatements performance
I know that PreparedStatements are parsed once, so typically they execute faster.
But consider following query:
select *
from plc
join qsn on qsn.id = plc.fk_qsn
join prs on prs.id = qsn....
1
vote
2answers
9k 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>
...
2
votes
0answers
329 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 ...
4
votes
1answer
5k 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>
&...
1
vote
2answers
144 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;
+----------------------+----------+
| ...
1
vote
2answers
57 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; ...
2
votes
0answers
756 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 ...
0
votes
1answer
756 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
1answer
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:
...
-2
votes
1answer
97 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
1answer
268 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?
3
votes
2answers
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 ...
0
votes
0answers
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 ...
1
vote
1answer
73 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 ...
2
votes
1answer
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 ...
3
votes
1answer
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, ...
21
votes
1answer
17k 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 ...
2
votes
3answers
214 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 <...
6
votes
1answer
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 ...