Questions tagged [parse]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
86 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
29 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
12 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
77 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
87 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
23 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
55 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
420 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
571 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
38 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
3k 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
236 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 ...
2
votes
2answers
3k 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
112 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
54 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; ...
1
vote
0answers
648 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
499 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
1k 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
239 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
72 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, ...
17
votes
1answer
13k 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
212 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 ...