You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Oracle great and have the most points for this month!
NOTE: This forum is for non-product questions and discussions on the Oracle database platform. Please post Toad-family product questions in their respective product forums. Thanks!
i have two separate query like this, only different with this two query
on first query i am using nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)
on second query i am using and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)
i need a column like item_code model_name color_name >value <=value
give me some suggestion
im.ITEM_CODE, wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, sum(cd.ITEM_PIECES), SUBSTR(wm.MODEL_NAME_ARB, 0, INSTR(wm.MODEL_NAME_ARB, '-')-1), ww.current_balancefromcontract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses wwwhere
cd.MODEL_NO =im.MODEL_NOand im.item_code=ww.item_codeand cd.COLOR_CODE =im.COLOR_CODEand cd.COLOR_CODE =wc.COLOR_CODEand im.WOOD_CODE =im.WOOD_CODEand cd.CONT_NO =cm.CONT_NOand cd.MODEL_NO =wm.MODEL_NOand cm.BRANCH_CODE=cb.BRANCH_CODEand cd.MODEL_NO <>'BDB0026'and substr(wm.MODEL_NO,-4) =:mand cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)and nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)and ww.wh_code = 'WH50'and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)and cm.CONT_STATUS not in('DW','DL','CN','SP')and cm.branch_code not in ('11','13','15','16','17','18','20','21','22','23','24')group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balanceORDER BY wc.COLOR_NAME_ENG
cd.MODEL_NO =im.MODEL_NOand im.item_code=ww.item_codeand cd.COLOR_CODE =im.COLOR_CODEand cd.COLOR_CODE =wc.COLOR_CODEand im.WOOD_CODE =im.WOOD_CODEand cd.CONT_NO =cm.CONT_NOand cd.MODEL_NO =wm.MODEL_NOand cm.BRANCH_CODE=cb.BRANCH_CODEand cd.MODEL_NO <>'BDB0026'and substr(wm.MODEL_NO,-4) =:mand cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)and ww.wh_code = 'WH50'and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)and cm.CONT_STATUS not in('DW','DL','CN','SP')and cm.branch_code not in ('11','13','15','16','17','18','20','21','22','23','24')group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balanceORDER BY wc.COLOR_NAME_ENG
I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html):
ORA-12638: Credential retrieval failed
If you get this error first you need to check the SQLNET.ORA file. This file is located in [Oracle_Home]/NETWORK/ADMIN/SQLNET.ORA
if you see SQLNET.AUTHENTICATION_SERVICES= (NTS)
this needs to change to SQLNET.AUTHENTICATION_SERVICES= (NONE)
after that try to login to the database
My company has an Enterprise license for Toad and I am running Toad 2.3 on Yosemite (Build 201510210824).
Toad worked fine until I rebooted my Mac and now it's perpetually stuck on "Initializing connections and drivers".
A check of "Force Quit" has Toad "not responding". Anyone have an idea how to fix this? I have tried uninstalling on my Mac and re-installing but apparently there are some residual files since it tries to keep making the same connections, perhaps a complete and total uninstall will fix it.
Many thanks for any pointers in the right direction
I am new to SQL database queries and am looking for help on how to execute this one.
I think I need to use a subquery, not really sure, so I will try to break it down in steps. What I would like to do (in one query) is...
Step 1: return all the rows in the table where ERROR_CODE=3
Step 2: take all the SERIAL_NUMBERs from Step 1 and query the table again for all rows containing those SERIAL_NUMBERs
Step 3: group the results of Step 2 by SERIAL_NUMBER
Step 4: order the rows within those groups by TIME_STAMP in descending order
Step 5: order those groups by the maximum TIME_STAMP value in each group in descending order
Thanks in advance,
I'm looking to take a query result like, i have a column in table (amount) but i would like to split the column like greater than 1000 should be in A column & less than 1000 should be in B column.
is this posible,
when I query on tables in my database for some column in toad output column there is coming questions mark e.g., "???D" .
When same query is performed on SQL plus editor it is giving correct data.
Can any one please help to resolve this issue that why I am getting those questions mark in output column?
Thanks in Advance.
I tried to import a Excel file into a Table using the "Import Table Data" component of Toad for Oracle.
During the setting i don't see a way to remove the null rows.
The only thing that i can use to restrict the input is "Last row".I can't use "Last "Row" because the Import step is performed for file with various number of rows.
Is there a way to remove this null rows ?
I am starting a new free e-magazine with the goal of sharing my code and tips and providing a medium for others to sharing. I'd like invite everyone to check it out. I hope it is helpful to everyone. Also, anyone that is interested is welcome to contribute.
Hi,I tried in every way to pass a variable to a simple sql script but it doesn't work.
i have tried to use #, % and other but the only way that don't see error is : after the name of variabile.
My script is:
Update table set field = :my_var where field is null;
I am a newby in SQL, hence I have a simple question:
"How shall I modify
BETWEEN to_date(ADD_MONTHS(-4,'2015/08/31'), 'yyyy/mm/dd hh24:mi:ss') AND to_date('2015/08/31 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
in order to make a rolling window work with only one date entry - the end period date, instead of manually updating the start date as well?"
I am using Toad Data Point for Oracle.
Many thanks in advance for your time!
Hi, could someone please help me convert the following query in order to use ansi joins? Thanks!
FROM VRW_ECL_EXP_DCLF_COMM_DTL_M0 DECLARACION, VRW_ECL_EXP_DCLF_PRDT_DTL_M0 DETALLE_ITEM, VRM_ECG_TRSP_DOC_M0 DATOS_CARGA, VRM_ECG_MNFT_EXP_DCL_M0 MAPEO_DCL_BL
where DECLARACION.Exp_dcl_mng_no = DETALLE_ITEM.Exp_dcl_mng_no and MAPEO_DCL_BL.EXP_DCL_NO(+) = DECLARACION.EXP_DCL_MNG_NO and MAPEO_DCL_BL.MRN = DATOS_CARGA.MRN(+) and MAPEO_DCL_BL.MSN = DATOS_CARGA.MSN(+) and MAPEO_DCL_BL.HSN = DATOS_CARGA.HSN(+) and DECLARACION.dclf_send_dt between to_date('&FECHA_DESDE'||'00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('&FECHA_HASTA'||'23:59:59','yyyy-mm-dd hh24:mi:ss')
Hi guys, I want to extract data from oracle database and transfer it into MongoDB and i wish to use some programming language rather than an ETL tool. So can anyone suggest me some programming language(like Python) to do this and the process of how to do it?
Initially i have to transfer all data from oracle and after that on a timely basis i have to transfer newly inserted rows in MongoDB.
Appreciate any king of help.
if you run the query below by pressing F9, the data returned in the data grid will show a leading space. However if you run it via F5, the leading space is not displayed in the data grid. Does anyone have a way to make the leading space display via F5?
select ' test' from dual;
this is a greatly scaled down sql statement. I am actually trying to see records with leading spaces in a pl/sql block that must be executed via F5.
We're hoping you're coming to Oracle Open World that started on Sunday and goes through Thursday. I got a last minute ticket and would love to hear from you and meet you in person and hear what you think about Toad World . Come on by the Dell Booth #1401 in Moscone Center South Exhibition Hall or the Toad Customer Party on Tuesday, September 30th at Lucky Strike in San Francisco. See you there. -Chris
Data available in the DB:
Data to be retrieved as follows
please help me over this senario...