I have a table table1 f_name f_content test1.txt YL*1**50*1~ RX*1~ LR*2~ test2.txt YL*1**49*1~ EE*1~ WW*2~ f_content is CLOB f_name is varchar2 (…
Tag: oracle
How retrieve all parent and child rows population in Oracle sql?
I have a table “TB_Population” with some records about the population from all over the world. at this time I want to calculate each title’s population in particular row and demonstrate each level in …
How to get column names from a query?
I have a specific query with joins and aliases, and I need to retrieve columns name for a REST request in Talend. I’m using Talend Open Studio for Data Integration 6.2 and I’ve got an Oracle 11g …
How to retrieve rows between hours
I want to get all rows from my table, the table have one column with the following date type ’14/07/2017 05:01:35 p.m.’ between specific hours. Like between ’00:01:00 am’ and ’01:00:00 am’. I’m …
My PLSQL trigger is not looping through the table
I have a group project and we are using PLSQL to make a shopping cart application. We are creating a trigger in order to cancel a shopping cart and return all of the items back to stock. As it is now, …
SQL group by with condition
Imagine i have a table like below: ID Score someOtherColumns 1 1 …. 2 1 ….. 3 4 …. 5 2 …. 6 1 …. where score can have an intger …
oracle sql find overlapping values between two sets
I have two tables (‘stock’, ‘website’) have the same structure both has one called ‘product_id’ I want to find out in what percentage the product_id in the ‘website’ table also in ‘stock’ table Did …
Execute two UPDATEs on complementary data at once in Oracle
I have the following table that I need to update: USER: | ID | ACTIVE | REF_COL | COL_2 | COL_3 | |—-|——–|———|——-|——-| | 1 | 1 | value | value | value | | 2 | 0 | …
Counting the number of words in a Column in Oracle SQL
How do you group this data, based on Patterns? Is it possible in SQL? CREATE TABLE ABC (“NAMES” VARCHAR2(50 BYTE)) ` `INSERT INTO ABC (names) VALUES (‘CA Apple 3’); INSERT INTO ABC (names) VALUES (…
Split comma separated values into multiple rows – Oracle SQL
I have a table table1 TEST_TYPE H_LEVEL HADOOP 22RETGGEDGDD, RRMMNFNEDGDD Control Directory 1 Interchange Control Header 22RETGGEDGDD, RRMMNFNEDGDD …