Reputation
2,459
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
15 36
Newest
 Tenacious
Impact
~227k people reached

Jun
17
comment oracle AQ for scheduled jobs
I used oracle AQ to receive changes from multiple tables, queue them and then shoot the changes to another database. There were never any issues with the modest amount of transactions I had ( <200/day). What are you looking for: how to set up, how to queue or???
Jun
17
comment How to correct this script restore and recover database on Oracle?
what is the problem when you tried this?
Jun
15
reviewed Approve Moving from Oracle 11.2.0.1 to 11.2.0.3
Jun
15
answered Moving from Oracle 11.2.0.1 to 11.2.0.3
Jun
12
revised Union of data from all tables with name containing a substring
added 140 characters in body
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag There you go, my lesson is don't code from memory, run it through the compiler!
Jun
12
revised Union of data from all tables with name containing a substring
added 35 characters in body
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag what is the characteristic of the tables you don't want?
Jun
12
comment Union of data from all tables with name containing a substring
@MelvynDrag see my edit
Jun
12
revised Union of data from all tables with name containing a substring
added 123 characters in body
Jun
12
answered Union of data from all tables with name containing a substring
Jun
10
awarded  Tumbleweed
Jun
3
asked Pipelined function returning anydataset
Jun
1
comment number field in varchar2 field
I feel the pain of a bad database design
May
20
comment Passing filter params to a sub query
do you want to change the parameters of the view on demand? What you have will create a view which does not change unless the underlying data is changed. If you want to adjust the parameters then a cursor would do. Please clarify what you want to do, what is the problem you want to solve?
May
20
comment Passing filter params to a sub query
do you want to change the parameters dynamically, in which case a view is not the object of choice, or....
May
5
comment Tune Performance by putting large tables into the KEEP Pool
I think you would get more success by optimizing the queries than putting tables in memory
May
4
comment TNSNAMES.ORA is located in Windows 2012 Server
Could be a lot of places depending on whether the install was standard or custom. Windows search will find how many versions you have
Apr
22
comment I have a table from which I can retrieve information but I cannot update or delete information
what database and what version? Do you have rights to update and delete but not select for that table?
Apr
20
comment Do data types go into a Relational Data Model (RDM)?
Most people like the lines between tables to not cross. takes more work but even a large diagram can be a thing of beauty if you take the time.