I need collect statistics for my long SQL-scripts. Script files generated by Java application and execute by third-party fast DB-driver. In this way I can't use AUTOTRACE, because it`s not SQLPlus. But for perfomance reasons I need to know stat information about every statement in script. Can you advice approaches or best practices? I...
He is there a function or setting which automaticly save's the form's data when a user forgot to press save? Like Word has? ...
I'm bewildered by a query in Oracle which is returning in a seemingly random order. SELECT Date, Amount FROM MyTable WHERE Date = '26-OCT-2010' ORDER BY Date This returns the following data: | Date | Amount -------------------------- 1 | 26-OCT-10 | 85 2 | 26-OCT-10 | 9 3 | 26-OCT-10 | 100 I cannot fathom...
I am trying to utilize transaction functionality in Oracle SQL for the first time and can't seem to find a good explanation. I understand that starting a new session will begin a new transaction. I also understand that commit/rollback is used to end it. What I am trying to do is execute two statements and if I either of them fail, und...
So I have lots DB tables. I need to port my DB into Oracle. I have no problems on MySQL but must port onto oracle. so what are main tips&trics when going oracle from mysql? ...
I need this to be done in Oracle SQL (10gR2). But I guess, I would rather put it plainly, any good, efficient algorithm is fine. Given a line (or sentence, containing one or many words, English), how will you find the last word of the sentence? Here is what I have tried in SQL. But, I would like to see an efficient way of doing this. ...
Hi, I'm unable to connect Oracle 10g database.I am getting exception java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver The code is: try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(ClassNotFoundException e) { e.printStackTrace(); } try { con=DriverManager.getConnection("jdbc:oracle:thin:@local...
I have two stored procs, p_proc1 and p_proc2. p_proc1 returns a refcursor and I want to use the data in p_proc2. Is it possible call p_proc1 in p_proc2 and modify the dataset (outer join another table)? The database is Oracle. ...
Can Oracle Materialized views be used to join multiple related tables having foreign keys to create a larger denormalized big table which is refreshed instantaneously? On some investigations, it says that joins are not allowed while using fast refresh. Is it my assumption which is wrong that i can do this sort of thing with Oracle Mate...
I want to achieve this .. update Table_A c set c.Column1 = (select d.column1 - b.column2 from Table_B d, Table_A b where b.primary_key = d.primary_key) But for outer query there is no primary key clause i have added.. How do i achieve it ...
I need some software to reverse engineer my Oracle forms to a diagram like UML (cannot because Oracle forms use functions) or DFD or CFD (SSADM). Any ideas on what to use? ...
Using SSRS with Oracle DB is not orthodox, but still i am forced to use it. So, while i am working on my reports, if another collegue of mine tries to do a query on the same database, an error occurs, on the TNS Listener. When i check the number of sessions active or inactive, they are in the limit secified. After i close and reopen the ...
Hi I was trying to execute grant all on Owner.table_name to APPS,ABC; but it is giving an error that grant privileges not provided. Please let me know how can i get and what is the reason. ...
My test-database has a AL32UTF8 encoding, however the production database has a WE8ISO8859P1 encoding. My application is writen in .NET and I use the default System.Data.OracleClient.OracleConnection class to make the connection. I create a IDbCommand and I add IDbDataParameter objects when I want to INSERT some strings with non ASCII s...
I have an Oracle table which contains data like 'Shiv------Shukla' (consider '-' as space). Now I need to write a program which leaves just one space and removes all other spaces. Here is the program which I've made but it is not giving me expected result. DECLARE MAX_LIMIT VARCHAR2(50):=NULL; REQ VARCHAR2(20):=NULL; CUR...
Hello all, this is actually a followup from a previous question but it contains different information , so I decided to start a new topic. Summary : I have 2 tables one TMP_TABLE and a BKP_TABLE. Both have the same fieldstructure and identical datatypes for the fields( with almost identical data). let's say TMP_TABLE is construc...
I have this query: SELECT to_number(gr.code) group_index, gr.NAME group_name, f.*, gr.description gr_desc FROM obj$groups gr, obj$group_objects gro, obj$group_objects gro2, tdf$flex_fields f, inv$requests w, inv$Direction_...
I am working on a system using Oracle DB. An ETL tool (ODI) put the following trigger on a table to enable changed data capture (CDC). create or replace trigger SCHEMA.T$TABLE_NAME after insert or update or delete on SCHEMA.TABLE_NAME for each row declare V_FLAG VARCHAR(1); V_ROW_ID VARCHAR2(60); begin if updating then ...
The error is very simple. There are 3 Tables, Lets name them A, B, C - All of them have 7 rows. A has the following data 1 2 3 4 5 6 7 with Id = 1 B has the following data 8 9 10 11 12 13 14 with Id = 1 C has the following data 15 16 17 18 19 20 21 with Id = 1 Now i am selecting them as : select A.col1,B.col1,C.col1 from...
Hi all, I have a requirement to be implemented with SSO, spefically the Oracle SSO with OID. The requirement may not be so SSO-like. The user will need to have two logout options: Global logout (which will be the SSO logout, invalidating the session in all logged in applications). According to what I have read, Oracle SSO achieves th...