I want to know about Which language is best for long term career and How? Which language should I choose among Java and .NET Platform or Should I choose Oracle like DBMS Language (SQL/PLSQL)? I am confused? Detailed answer would be appreciated. ...
Possible Duplicate: Oracle: is there a tool to trace queries, like Profiler for sql server? Is there any option in Oracle like Sql profiler to trace the query running in the backend ...
Is there any article/link available where I can find examples of SQL tuning(Oracle). It would great if it is explain with example. I need something like existing query, statstics, plan and then suggested query/recommendation and new plan. I found couple of really good links on google: http://www.dba-oracle.com/art_sql_tune.htm http://...
Hi, guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly. declare type a is table of number; type b is table of a; arr b := b(a(1, 2), a(3, 4)); begin for i in arr.first .. arr.last loop for j in arr(i).first .. arr(i).last loop dbms_output.put_line(arr(i) (j)); end loop; end ...
Hi, I'm calling a third party stored procedure in Oracle from VB that is not rolling back. Code first (I'm simplifying): Connection string: String sqlstr = "SERVER=x.x.x.x;Database=db;uid=sa;pwd=admin;Connect Timeout=60; Min Pool Size=5; Max Pool Size=100;"; The call (I've just forced a rollback immediately after the execute to tes...
Hello all, I am a junior oracle DBA.Now I am graduating my university and there I should present senior project about my desired topic..I need help.What topic should I choose? What will be useful for me to deeper my knowledge about Oracle database? Thanks a lot in previous. ...
Hi, I need to do some auditing on updating a row. So I have a function that receives a parameter of type some_table%ROWTYPE, containing the new values to be saved for that row. I also need to save some info in a history table regarding what column values where changed. I was thinking of getting the column names for some_table from all_...
How can I, in Oracle 11, insert large data (~100000 hex-digits) into Blob field, using sql command only (without any external data with load cluase or such). update tablename set fieldname='AA'; Works - 1 byte; update tablename set fieldname='AA...(4000 hex-digits)...AA'; Doesn't. Niether Concat helps; strings can't be larger than ...
Hi, i want know querys of third party software executed in my oracle server, anybody know how i can do that?i will use one time, can be trial software or script anything..thx ...
I need to write a procedure to normalize a record that have multiple tokens concatenated by one char, I need to obtain these tokens splitting the string and insert each one as a new record in a table. Does Oracle have something like a "split" function? ...
I have the following tables: users - userid - real name - other stuff roles - roleid - description - other stuff functions - functionid - description screens - screenid - description A user can have multiple roles, as controlled by the table user_roles - userid - roleid Each role can have either edit, view or no acce...
First of all I am using Oracle 10g Express So there are three columns I want to select: [domain_name] [index_path] [collection_name] Now there are two columns that I want to be unique: [domain_name] [index_path] So my issue is how do I basically: select unique domain_name, index_path from TABLENAMEHERE while also selecting the c...
I have configured ssl through net manager after added ewallet which is in READY mode. I even restarted the all the database services. But I am not able to figure the reason the listener not working. Need advise and let me know if you need anyother log or config files.. sqlnet.log: Fatal NI connect error 28750, connecting to: (DESCR...
First of all I am using Oracle 10g Express So there are three columns I want to select: [domain_name] [index_path] [collection_name] Now there are two columns that I want to be unique (as a group): [domain_name] [index_path] And then I want to select the row baised on when another column [gen_timestamp] is most recent. So my issue ...
Hi! I have table with a column that contains multiple values separated by comma (,) and would like to split it so I get earch Site on its own row but with the same Number in front. So my select would from this input table Sitetable Number Site 952240 2-78,2-89 ...
hi i have 2 tables table1: num,X,Y table2: num,X,Y i need to update X and Y in table1 where table1.num = table2.num how to do it ? i need it in Oracle query (i think that in sql server it will work too) thank's in advance ...
Hi all! In our project, we have all DB manipulations concentrated in Oracle stored procedures. Result sets is returned by OUT parameter of SYS_REFCURSOR type. Now we have a task to make pagination, and we don't want to rewrite all of our procedures, adding 2 parameters (pageNumber and pageSize) to them and editing WHERE clauses. We have...
First, I hope this is the right place for this question. Because I believe this to be a server configuration problem, I wasn't sure if this should go on serverfault. So we have a spring-mvc webapp running on Tomcat servers and connected to an Oracle database. On one of these pages is a form for the user to fill out where they can enter ...
I am converting some code from VB RDO (using an ODBC cursor) to ADO.NET Some of the old VB code loops through the RDO errors collection to get any ODBC or Server errors and log them accordingly. I've converted the code using Data.Common objects (ex: DBCOnnection, DBCommand) and using Datasets and ODBC. (I am NOT using Oracle .NET Prov...
I just want to see whether the data is getting inserted on the table or not.. So i have written like this: select count(*) from emp; dbms_lock.sleep(1); select count(*) from emp; So that it will sleep for 1 min . Even after sleep if the 1st count and 2nd count are different then the data is getting inserted into the table. Otherwise...