Reputation
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
9 33
Impact
~162k people reached

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