Questions tagged [parse]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
jubey simanjuntak's user avatar
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 ...
bravo4one's user avatar
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. ...
Rushabh Mehta's user avatar
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 ...
Zikato's user avatar
  • 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 ...
r0tt's user avatar
  • 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 ...
Kopite833's user avatar
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 @...
StealthRT's user avatar
  • 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 ...
Jason Yang's user avatar
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). ...
Ronaldo's user avatar
  • 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", &...
jrdba123's user avatar
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-...
JoL's user avatar
  • 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 ...
Tyler Hahn's user avatar
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/...
learning's user avatar
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 ...
Display name's user avatar
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 ...
eckes's user avatar
  • 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 ); $...
Ron Piggott's user avatar
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:...
J. Taylor's user avatar
  • 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 ...
user avatar
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 ...
shawnyshawny's user avatar
-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 ...
E.Rawrdríguez.Ophanim's user avatar
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 ...
mpen's user avatar
  • 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 ...
klor's user avatar
  • 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> ...
Mel's user avatar
  • 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 ...
FeanDoe's user avatar
  • 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> &...
michal's user avatar
  • 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; +----------------------+----------+ | ...
LawrenceLi's user avatar
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; ...
Jim's user avatar
  • 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 ...
Leonid's user avatar
  • 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 ...
Garrett Culos's user avatar
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: ...
ffuentes's user avatar
  • 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.
Charlie M's user avatar
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?
Andrey Gordeev's user avatar
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 ...
Junior Mayhé's user avatar
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 ...
Blama's user avatar
  • 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 ...
RedFux227's user avatar
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 ...
Roy's user avatar
  • 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, ...
Ertiti's user avatar
  • 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 ...
swasheck's user avatar
  • 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 <...
user avatar
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 ...
René Nyffenegger's user avatar