Reputation
2,240
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
11 35
Newest
 Caucus
Impact
~184k people reached

Jul
27
awarded  Caucus
Jul
16
awarded  Yearling
Jul
10
answered Select all from table using procedure oracle
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
9
revised Verbose Oracle RDBMS error log output examples?
added 304 characters in body
Jul
9
answered Verbose Oracle RDBMS error log output examples?
Jul
8
awarded  Notable Question
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
4
revised How to select a row based on the maximum value of a column, when ties are expected
corrected incorrect syntax
Jul
4
answered Migrating Oracle 9i database to MySql database on a different Windows Server
Jul
3
answered How to select a row based on the maximum value of a column, when ties are expected
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
29
answered What does Oracle XE perform during installation?
Jun
25
reviewed Approve What is the privilege for account unlock in Oracle
Jun
25
answered What is the privilege for account unlock in Oracle
Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
added 2 characters in body