I have a requirement to fetch value based on eff_dt and end date. given below sample data. Database : Oracle 11g Example data: id val eff_date end_date 10 100 01-Jan-21 04-Jan-21 10 105 05-Jan-21 07-Jan-21 10 100 08-Jan-21 10-Jan-21 10 100 11-Jan-21 17-Jan-21 10 100 18-Jan-21 21-Jan-21 10 110 22-Jan-21 null output: id val eff_date end_date 10 100 01-Jan-21 04-Jan-21 10 105 05-Jan-21 07-Jan-21 10 100 08-Jan-21 21-Jan-21 10 110 22-Jan-21 null
databaseanswers.net Latest Questions
Their TOT and CNT are getting 0 after Loop running. My input is 5 but the result always got 0 why?? I want to input multiple times by the user. Is it possible??????? DECLARE ...
I’m working with both SQL Server and Oracle database I got confused by this: This is my query to obtain the highest value thrown by SQL statement: select MAX(CaseNumber) as CaseNumber from claims
I have 3 tables (Potions and Reagents and relation of both) and I want to pivot the results, pass to explain: TABLE POTIONS ID DESCRIPTION 1 Heal 2 Mana 3 ...
I have to filter one column (Product_Name) but I need to show only results which does not include symbols ‘_’ and ‘<‘ any ideas? SELECT p.PRODUCT_NAME,oi.QUANTITY as "TOTAL_QUANTITY",o.ORDER_MODE from PRODUCT_INFORMATION p join ORDER_ITEMS oi on p.PRODUCT_ID = oi.PRODUCT_ID join ORDERS o on oi.ORDER_ID ...
How to create a 2D varray in Oracle?? It can be a string array or an integer or both.
ORA-39112: Dependent object type CONSTRAINT:"xxx7" skipped, base object type TABLE:"xxxx" creation failed ORA-39112: Dependent object type CONSTRAINT:"xxx7" skipped, base object type TABLE:"xxxx" creation failed I am getting the following ORA-39112 error when running an import? How do I fix the ORA-39112 ...
I’m using ORACLE 11G database I have a table which have these columns: item, cod_line, business, cod_business, cod_ez_catalog_product_brand, business_unit, last_update_date It is called: products_table Take a look (i’m filtering for a specific product): SELECT item, cod_line, business, cod_business, cod_ez_catalog_product_brand, business_unit, last_update_date from products_table WHERE ITEM = '94TERFERE' I’m ...
We are using the Oracle database. I have a table with the below records OrderNumber ----------- JK-PO-01 JK-PO-02 JK-PO-03 Using PL/SQL, I would like to get the latest order number (JK-PO-03) I tried getting the count of the order group and prefixing count var to JK-PO- ...
I have a table connection_master in that table column name status_conn have 1 value for ON conn. and 2 for OFF conn. now I want to get only counts of ON and OFF connections in one query I want output like ...