Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [parse]

38 questions
26
votes
1 answer

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 would like to join an unnested array of that string…
swasheck
  • 10,755
  • 5
  • 48
  • 89
6
votes
1 answer

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 unwrap a wrapped package (and that is useless for…
René Nyffenegger
  • 3,763
  • 7
  • 32
  • 39
4
votes
2 answers

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 exists in a table. When you run your script, SSMS…
Junior Mayhe
  • 337
  • 1
  • 2
  • 12
4
votes
1 answer

xml parse in postgresSQL

I have a problem with parse simple xml: 1 IT 1 …
michal
  • 103
  • 1
  • 2
  • 6
3
votes
1 answer

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, etc...). The output columns should be something…
Ertiti
  • 31
  • 2
2
votes
2 answers

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 script to SQL Server 2008?
jubey simanjuntak
  • 21
  • 3
2
votes
1 answer

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 column to a list of values. Will Oracle consider these…
Roy
  • 1,060
  • 5
  • 16
  • 39
2
votes
2 answers

Extract data from an xml fragment

In SQL Server 2014, I have the following xml fragment : 123 2017-04-17
Stationery Pencil …
Mel
  • 23
  • 1
  • 1
  • 3
2
votes
0 answers

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 a blank space. If I debug the parser I get the…
FeanDoe
  • 183
  • 1
  • 1
  • 5
2
votes
0 answers

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 the algorithm that nzsql command line utility is…
Leonid
  • 121
  • 3
2
votes
3 answers

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 I want to algorithmically turn all…
user843
1
vote
1 answer

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 type or there is another better option of storing likes in Parse DB?
Andrey Gordeev
  • 111
  • 4
1
vote
1 answer

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 upper and lower case, does it mean they have to do…
RedFux227
  • 43
  • 1
  • 3
1
vote
0 answers

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 a syntax error in one of the scalar…
Zikato
  • 5,619
  • 1
  • 17
  • 34
1
vote
3 answers

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 statement: 9915 2021-08-24T11:01:17.843825+02:00 9916…
r0tt
  • 1,078
  • 7
  • 32
  • 54
1
2 3