1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen 22 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


1d
asked Replacement for Pragma Restrict references
Oct
17
comment grant permissions in oracle from one database to another
Are they actually two different instances on the same machine? Or two schemas on the same machine, or two instances on different machines?
Sep
24
awarded  Autobiographer
Sep
22
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
Ah, Forms... You can do stored procedures in Forms and skip the triggers if you like.
Sep
22
answered Compare sysdate month with a column data
Sep
19
answered How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
Sep
19
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
You are really handcuffing yourself with all the things that cannot be changed. Have you considered Advanced queues, or a table that is inserted into every time a row is changed?
Sep
18
comment Oracle remote OS authentication, security risks with domain users
what testing have you tried?
Sep
5
revised inconsistent type after querying search_condition column in all_constraints table Oracle
deleted 6 characters in body
Sep
5
comment Is it possible to get this output in Oracle 8i?
What have you tried?
Sep
4
answered inconsistent type after querying search_condition column in all_constraints table Oracle
Sep
2
comment How to put more than 1000 values into an Oracle
Can you create an external table in a directory?
Aug
28
revised How to create a function(table_name) that return a collection in Oracle?
corrected syntax error
Aug
28
revised How to create a function(table_name) that return a collection in Oracle?
corrected syntax error
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?