1,817 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years, 1 month
seen 9 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
16
awarded  Yearling
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?
Jul
2
awarded  Curious
Jun
23
answered ORA-00907: missing right parenthesis on query with subqueries
Jun
23
revised How to create a function(table_name) that return a collection in Oracle?
added 68 characters in body
Jun
23
answered How to create a function(table_name) that return a collection in Oracle?
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'||