Reputation
2,240
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
12 35
Newest
 Constituent
Impact
~185k people reached

Jul
9
comment Oracle's (+) notation within function
@Vérace if they ever want to move to a different database old style joins will be the least of their problems. PL/SQL code will have to be rewritten as ANSI compliant is a flexible term for vendors
Jul
6
comment Is Oracle Wallet available for use with Oracle XE 11gR1
ask an Oracle licencing rep. it's the only way to be sure
Jul
2
comment Migrating Oracle 9i database to MySql database on a different Windows Server
it would help if you told us how the vb application accesses the Oracle date...prepared SQL statement, stored procedures, ORM tool??
Jul
2
comment Migrating Oracle 9i database to MySql database on a different Windows Server
just change the connection string in the web config to point to the new database in your project. ensure that visual studio and the new server have the dll's to connect to mysql
Jul
1
comment What does Oracle XE perform during installation?
Yes, you don't need a listener for a client installation. It was not clear from your question where you say you installed two Oracle databases that you only wanted a client install
Jun
30
comment Why is my PL/SQL procedure so slow?
use trace and get some profiling done on what it is doing.
Jun
30
comment What does Oracle XE perform during installation?
Every Oracle database that connects outside a machine is listed in a listener. I don't have access to my test box so I can't tell you whether you have two listeners, one for each install, or one that lists both
Jun
22
comment Will an update in my trigger trigger itself? Oracle PLSQL
Sounds like a recipe for the error: table is mutating, trigger may not see new state
Jun
19
comment oracle AQ for scheduled jobs
You can use DBMS_LOCK, docs.oracle.com/cd/B28359_01/appdev.111/b28419/… to generate unique names for your locks but the naming will not affect the type of processing. Can you post a test case?
Jun
18
comment oracle AQ for scheduled jobs
I don't know what you mean by "Pulls multiple exclusive locks". Are you referring to code that uses Select for update or Lock table commands? I am unaware of how you would name a lock or how that would help, more details please on the problem
Jun
17
comment oracle AQ for scheduled jobs
I used oracle AQ to receive changes from multiple tables, queue them and then shoot the changes to another database. There were never any issues with the modest amount of transactions I had ( <200/day). What are you looking for: how to set up, how to queue or???
Jun
17
comment How to correct this script restore and recover database on Oracle?
what is the problem when you tried this?
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag There you go, my lesson is don't code from memory, run it through the compiler!
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag what is the characteristic of the tables you don't want?
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag see my edit
Jun
1
comment number field in varchar2 field
I feel the pain of a bad database design
May
20
comment Passing filter params to a sub query
do you want to change the parameters of the view on demand? What you have will create a view which does not change unless the underlying data is changed. If you want to adjust the parameters then a cursor would do. Please clarify what you want to do, what is the problem you want to solve?
May
20
comment Passing filter params to a sub query
do you want to change the parameters dynamically, in which case a view is not the object of choice, or....
May
5
comment Tune Performance by putting large tables into the KEEP Pool
I think you would get more success by optimizing the queries than putting tables in memory
May
4
comment TNSNAMES.ORA is located in Windows 2012 Server
Could be a lot of places depending on whether the install was standard or custom. Windows search will find how many versions you have