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 used DROP table command to table EMP in my INFO schema. But I can still see the table structure using DESC EMP command in toad.Why is this so.Is my toad misbehaving?
I have a Oracle AWR report that shows that Temp Table Indexes are having ROW LOCK WAITS.
The Temp table is defined as ON COMMIT PRESERVE ROWS
Question: What scenarios can a Temp Table Index have ROW LOCK Waits ??????
I would like to launch a toad script from MS Access. The script would call a Toad Stored procedure or SQL that would create a table. This table would be used by MS Access to create reports/pivot Tables/etc. Our company does not allow ODBC access to oracle whatsoever period. My hope would be to launch a script from Access that calls a toad procedure that gets data from Oracle and creates a table on my local drive. In summary MS Access => Toad =>Oracle. Can this be done?
Thanks in advance for the help
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.
Hi guys, how can i log off a user connected to a database. The user was previously logged on in an application
that using database, but didnt shut down his system properly and now the user tries to login and his getting
and error message "this user is already logged in".
Now, how can i totally log out the user "back-end" to enable the user login access?
I have many base, users and links. I need to know that who is using db links?
Hi all in my db NLS_CHARACTERSET=W8ISO8859P1.
in TOAD i see dirty characters, i have created ENV_Variable with name NLS_LANG="AMERICAN_AMERICA.AR8MSWIN1256" and also i have setted this in WINDOWS registry,but it didn't change dirty characters. how can i solve problem? please guide me !
While using the utility for comparing multiple schemas, I have an inclusion Option set up like this:
One of my schema's however returns a differences like this:
Based on the logic of the inclusion option, shouldn't these objects be excluded?
FOR vll_use IN cur_vll LOOP v_item := vll_use.item; v_dest := vll_use.dest; v_aggqty := vll_use.aggsupqty;
FOR sk_lir IN cur_sk_lir LOOP v_aggqty := v_aggqty - sk_lir.needqty;
CASE WHEN v_aggqty > 0 THEN UPDATE suppordersku sk SET status = 2 WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); WHEN v_aggqty = 0 THEN UPDATE suppordersku sk SET status = 2 WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); ELSE UPDATE suppordersku sk SET needqty = ABS (v_aggqty) WHERE sk.item = v_item AND sk.loc = v_dest AND sk.needarrivdate = sk_lir.needarrivdate; DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty); END CASE; END LOOP;
FOR sk_gui IN cur_sk_gui LOOP v_aggqty := v_aggqty - sk_gui.needqty;
How to avoid entering second loop i.e. cur_sk_gui if value of v_aggqty =0 after 1st loop???
suppose there is an office id column with 10 values and having billing status of 'c','l','d','i','n' i want the querry for the count using the decode function and the count should be equal to the office_id consumer numbers.
I created private db link. How to access another user that private link?
How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc. that were in 12.6 to display in 12.7? Thanks.
when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress. any one help me come over the error??????
i need one insert query in oracle but it will insert multiple row in table.
Please help me to do.
create or replace procedure GETINFO(P_IDS in IDS_TABLE) is --- IDS_TABLE is a table of object type conatins id1,id2,id3 cols. begin for I in 1 .. P_IDS.COUNT LOOP DBMS_OUTPUT.PUT_LINE(P_IDS(i).ID1 || ',' || P_IDS(i).ID2 || ',' || P_IDS(i).ID3); END LOOP; end GETINFO;
how to execute this procedure to get the out put?