I have Table Field1 PK int not null Field2 PK int not null like this when i want to map this table I get this error Error 3 Error 3034: Problem in mapping fragments starting at lines 2212, …
Tag: sql
Oracle Regular Expression (REGEXP_LIKE) Too Long Error – ORA-12733
I have to validate an IPv6 address in PL/SQL. I came up with the regular expression from here: Regular Expression (RegEx) for IPv6 Separate from IPv4 I am getting an ORA-12733: regular expression too long error. Is there any way around this? The limit is 512 (https://stackoverflow.com/a/2694119/3112803), I…
Does Liquibase support dry run?
We have couple of data schemas and we investigate the migration to Liquibase. (One of data schemas is already migrated to Liquibase). Important question for us is if Liquibase supports dry run: We …
sql: scan row(s) with unknown number of columns (select * from …)
I have a table t containing a lot of columns, and my sql is like this: select * from t. Now I only want to scan one column or two from the wide returned row set. However, the sql.Scan accepts dest ……
SQL Server : round and add percent sign
I have the following SQL query that is returning a result of 92.967013425802 and I need it to be formatted like 93% and add the percent sign. I have tried changing the sum to round but I received an …
How to use CTE’s with update/delete on SQLite?
SQLite now has CTEs, and the documentation says you can use it with insert, update and delete queries — but only gives examples of select statements. I can figure out how CTEs apply to inserts, via insert-select; but how can we use them in update or delete, where there is no from-clause? Answer CTEs can…
Where can I find SQL language specification [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 11 months ago. Improve this question Is there an official SQL standard? I.e. I want to understand what type…
How to read sql query from a txt-file in Java
I am having some some class that is sending queries to data base. Everything was working fine when the query was in the code, but as it’s pretty big, I decided to put it in a file and to read it with buffered reader, but it’s not working, I always get this: java.sql.SQLException: ORA-00900: invali…
T-SQL split string based on delimiter
I have some data that I would like to split based on a delimiter that may or may not exist. Example data: John/Smith Jane/Doe Steve Bob/Johnson I am using the following code to split this data into …
how to use dynamic query inside a function
i’m trying to create a function GETUSERPROP(prop, filter_prop, filter_value) that selects one item in database filtering by property and value SET @_GET_PROP = “name”; SET @_FILTER_PROP = “id”;…