Lab Sql

I have data like this 1,2,3,4-8,10,11 I want split the data into rows with these 2 rules : The , w… Read more Split Data In Sql With Multiple Delimiters ( , And - ) With Owns Rule

I want to get the list of numbers in between two columns. A tables values will be used to generate … Read more Get List Of Numbers In Between Two Columns With Key

I try to spool output in a nice way, so i am formatting all VARCHAR2 columns to a5. However, my pro… Read more How To Format A Number Column In Oracle?

I am using Adempiere which has database Oracle I have window called Stock Code from table called M_… Read more Create Leading Zero In Oracle

I cant figure out how to select the following: 123 -> 123.00000 123.12 -> 123.1200… Read more How To Expand Decimal Places Of A Number To A Minimum In Oracle Plsql?

I'm trying to create a MySQL query to update PAN no of all members. Using the query below I kee… Read more Mysql: #1292 - Truncated Incorrect Double Value: '...'