1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen 2 days ago

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


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.
Jun
18
awarded  Popular Question
Jun
12
revised Testing equivalence in strings with different character sets
added 324 characters in body
Jun
12
revised Testing equivalence in strings with different character sets
added 5 characters in body
Jun
12
asked Testing equivalence in strings with different character sets
Jun
9
revised How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously
spelling grammar
Jun
9
suggested suggested edit on How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously
May
28
revised How can I send an email when objects get invalidated?
added 180 characters in body
May
26
answered How can I send an email when objects get invalidated?
May
11
awarded  Popular Question
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
31
awarded  Popular Question
Jan
21
revised table wiki excerpt
added 66 characters in body