1,206 reputation
110
bio website valthor.net
location Reykjavik, Iceland
age 36
visits member for 1 year, 10 months
seen yesterday

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


Jan
9
comment How to create script file with PL/SQL?
Depending on your client, you might actually also want to try to look into using the DMBS_OUTPUT package and simply just write the output to the output screen of your client, and then saving that result as a file. It's not very elegant, but it would work.
Jan
9
answered Using Oracle Datapump when target table has additional column
Jan
9
comment How to create script file with PL/SQL?
There's not a specific package to achieve this, but you might find this helpful ; dba-oracle.com/t_oracle:__write_a_file_to_to_a_client_pc.htm
Jan
9
comment How to create script file with PL/SQL?
You sure can. Check out the stuff I just added to my answer
Jan
9
revised How to create script file with PL/SQL?
added 1809 characters in body
Jan
7
answered How to create script file with PL/SQL?
Dec
17
revised can I use many-to-many relation with weak entity
added 541 characters in body
Dec
17
answered can I use many-to-many relation with weak entity
Dec
4
comment How should I delete branch from adjacency list in SQL Server?
Just added another version of the proc, it goes by the parentNodeId. Should only iterate over the number of levels.
Dec
4
revised How should I delete branch from adjacency list in SQL Server?
added 945 characters in body
Dec
3
answered How should I delete branch from adjacency list in SQL Server?
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