1,817 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years
seen 8 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Jul
7
comment How to find out duplicate rows by using oracle 10g forms
I'm not sure what you are asking. Do you want an Oracle Forms solution or an SQL query?
Jun
19
comment Is there a way to pass to execute immediate only once a variable but use it several times?
What you don't say is why you want to do this. Intellectual curiosity or other reason??? You are not really "saving" anything by repeating it or using a different solution to not repeat it.
Jun
19
comment Low performance oci_execute
You would verify this by running it in your app and then running it again in your app. Compare execution times and see. Using SQL Developer should make no difference to the execution plan but running the same query twice will.
May
9
comment MS Access migration from Oracle to SQL server?
I think you should describe what oracle/sql server do and what access does in this project.
Mar
11
comment How can I receive an input string parameter having about 200000 characters?
why can't you use a clob? or break the input into manageable chunks?
Feb
25
comment dynamic query manupulation
this query would seem to need some spaces after the reserved key words. Such as ...dep.DEPT_ID=depgr.DPGR_DEPT_ID'|| ' ' || --added space here 'inner join hod_groups hod on depgr.DPGR_DEPT_ID=hod.HODG_GN_ID'||
Feb
22
comment Installing Oracle on Windows Server 2008 R2 Guested by VMware
This is only a warning not a failed installation. You should take a snapshot before installation. After the warning continue the install. After it is finished run the emca script as recommended
Feb
17
comment query to search a particular word/string in toad/oracle
Some versions of TOAD have an object search that will allow you to search in any package,procedure, trigger, table definition (not the data)
Feb
7
comment Installing Oracle Database 12c in Windows 7, INS-08109 error
I guess using a clean install of windows is not possible?
Jan
31
comment “Oneway” Replication from Oracle DB to TimesTen
What versions of Oracle and TimesTen are you using?
Jan
21
comment 1 time shrink of abused databse or restore from backup
what kind of database, oracle? what version?
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
Some developer somewhere should read up on the perils of mixing data types in the same column.
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
How about showing us the SQL statement that generates the error?
Jan
13
comment How to make stored procedures more readable without harming performance
Novick's article was written in 2005. Not being an SQL Server guy I can only assume that there have been positive changes since then in performance for nested subroutines
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
You have to help me before I can help you. What does the log say? Quote the exact error message.
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
look in C:\app\product\11.2.0\dbhome_1\YourServerName.YourDomain_YourDatabaseName\sysman‌​\log for emagent.log and emagent.trc
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
can you show us the install log? I would not assume that just because you get an error when starting Enterprise manager that there is a bug in the software.
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Have you considered that maybe this is a job for someone with more experience? It's not fair to you to try and fix up what appears to be a series of omissions. If you succeed then they will expect miracles again and if not then you get the blame....
Dec
16
comment Applying data changes from one database to another
I'm not clear on the idea of importing data from the development database into production. This seems to break the point of having production and development. What kind of data is this? New properties or characteristics or user entered data?
Dec
10
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
You can overuse synonyms and further muddy the question of "what does this refer to?". See here for more details on security, performance and best practices stackoverflow.com/a/10042117/851930