1,911 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 5 months
seen 16 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


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
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 approved 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