1,051 reputation
110
bio website valthor.net
location Reykjavik, Iceland
age 36
visits member for 1 year, 7 months
seen 23 hours ago

13 years of coding PL/SQL, T/SQL, and managing Oracle and MSSQL servers in enterprise environments. Mostly finance and telco


Oct
14
answered index rebuild/reorganize frequency
Oct
6
answered How to I establish a 1 to 1 relationship
Oct
2
answered Populate one table with data from another one on selected cells
Oct
2
answered capture output of table-valued function
Oct
1
answered Storing file into oracle db
Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
Sep
10
awarded  Revival
Jul
9
revised Null Or Multiple Parameters When Querying
added 208 characters in body
Jul
9
comment Null Or Multiple Parameters When Querying
Perhaps I misunderstood the requirements, I thought he was asking for a split function of some sort. But sure, my select statement didn't account for returning all rows for an empty string. I'll update that.
Jul
9
revised Null Or Multiple Parameters When Querying
deleted 32 characters in body
Jul
9
answered Null Or Multiple Parameters When Querying
Jun
17
comment How to reference a table from another schema inside a package?
It's little hard determining the problem based on this information. Perhaps you could post your code here ?
Jun
8
answered Shrink my database log file, make sense?
Jun
5
answered create a stored procedure if it doesnt exist using a ddl in db2
Jun
5
comment Slow delete caused by many foreign keys
There's really no catch-all answer for this, you have to tune your index needs based on the characteristics of your system. You might want to reference this answer here for details: dba.stackexchange.com/questions/5525/…
Jun
4
revised How do I differentiate between user-defined public synonyms and built-in public synonyms?
added 547 characters in body
Jun
3
answered Slow delete caused by many foreign keys
Jun
3
comment Mapping the oracle database directory object to a network path
As long as the path is accessible from your local server, it should work. "Oracle Database does not verify that the directory you specify actually exists. Therefore, take care that you specify a valid directory in your operating system. In addition, if your operating system uses case-sensitive path names, then be sure you specify the directory in the correct format. You need not include a trailing slash at the end of the path name."
Jun
3
answered How do I differentiate between user-defined public synonyms and built-in public synonyms?