Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dagon
  • Content: Threads
  • Order by date
  1. Dagon

    Returning Confirm to HTML from JS function

    That works fine and the button action is cancelled if the user clicks Cancel on the confirm box. But I really want it to be a bit more sophisticated and take parameters to determine whether it displays the dialog box or not. As a first step, I have a JS function such as: function...
  2. Dagon

    PL/SQL Challenge

    If anyone is interested, Steven Feuerstein runs a site called the PL/SQL challenge, which offers a daily quiz to improve your PL/SQL skills. I only raise this as a way of boasting that today's question is one that I wrote. It's quite possibly the nearest thing I've ever managed to fame on the...
  3. Dagon

    How to Sort WM_CONCAT output

    I really like the WM_CONCAT function in 10g as a quick way of concatenating fields. However, it has one major drawback in that there is no way of ordering the fields in the string that it returns. So for example: create table test_sort (key1 number, data_val varchar2(10)); insert into...
  4. Dagon

    Strange Directory Issue

    I'm using Sun Solaris and I find that if I cd to one particular directory and do an ls, no files are listed. It doesn't matter what options I use on the ls command (I've tried -l, -f, -a). Adding an argument like a filename or directory makes no difference. However, if I do cd .. and then...
  5. Dagon

    Pipelined Procedure with Named Parameters

    Has anyone tried using table/pipeline procedures with named parameters ? i.e. SELECT * FROM table(package.myproc(my_param=>'xxx')) I get the error ORA-00907, but it works if I remove the "my_param=>". It looks as if it's not supported. Database version is 9.2.0.6.0.
  6. Dagon

    Using XML in Jar Files

    I know very little about Java, but have had the misfortune to be tasked with writing an extract program to get some data from a server via its API. The problem I'm having is understanding the instructions required to connect to the API and there's not much assistance available. The...
    • Dagon
    • Thread
    • Replies: 4
    • Forum: Java
  7. Dagon

    Writing to an Array of Files

    I was trying to do something similar to the UNIX split command. I am reading through a file and splitting the lines randomly between several output files. The number of output files is determined at run time by a UNIX environment variable. I was trying to do it by maintaining a line...
    • Dagon
    • Thread
    • Replies: 3
    • Forum: Perl
  8. Dagon

    NAWK Performance

    I'm trying to replace a convoluted piece of processing, which involves reading the same file 6 times, with a single nawk script. However, I'm having severe performance problems with the first stage of the processing. This involves cutting a set of fields from the file using a comma-delimited...
  9. Dagon

    Relational Databases - Oracle or SQL*Server ?

    After many years of working mostly with Oracle, I've been offered a 1-year contract working with SQL*Server. It would mean quitting my existing contract (which I don't mind, because it's rubbish). However, I have misgivings over whether I want to change technologies or not. Although I'd...
  10. Dagon

    Seeking a New Way of Working

    I have worked as a UK based contractor for several years. Essentially, it means sitting at a desk and working on whatever project I am told to, in exactly the same way as a permanent employee. I'm bored with this way of working: because of poor management and resource usage within the...
  11. Dagon

    Most Loathed Cliches

    I've never posted in this forum before, but it seems like a suitable place for me to have a little rant about my most loathed expression and ask if you have any more nominations. Here is mine: the ridiculous overuse of the word "unbelievable", especially by sportsmen. Every time I watch TV...
  12. Dagon

    Materialized View/Index Organization

    Has anyone managed to create a materialized view with index organization ? I have an MV which only has one column, so I wanted it to be index organized, but I'm really struggling with the syntax for it. My latest attempt is: create materialized view mv_annuity_tcns using index refresh on...
  13. Dagon

    Formula not re-calculating in Spreadsheet

    MS Excel 2000 I was editing a spreadsheet I inherited from someone and I was trying to add a formula to it, but can't get it to compute the formula. It just displays the text of the formula rather than the computed values. I have checked the tools/options/view/formula setting and the box...
  14. Dagon

    Where is the OnDelete Event ?

    I haven't used Access in about 5 years but I rather stupidly volunteered to fix a bug in a form. There is a master detail form and I want to amend it so that, if a parent record is deleted, it removes all the child records. I thought I would be able to do this by amending the "on delete"...
  15. Dagon

    DBMS_MVIEW.Refresh no_data_found

    Has anyone tried using the DBMS_MVIEW.Refresh package, passing an array of table names as a parameter (Oracle9i Enterprise Edition Release 9.2.0.4.0) ? I can get it to work with the "list" parameter but, if I try to use the version with the "tab" parameter, I get: * ERROR at line 1...
  16. Dagon

    Outlook New Message

    MS Outlook 2000 SP3 I have a load of routine messages that come from specific sources and I want to stop them being flagged as new messages. I can route them to a different folder, but they still come up as new message alerts. I don't want to turn off new message alerts altogether, just...
  17. Dagon

    Update & Insert Concurrency

    Running 9.2.0.4.0 - 64bit on solaris, I have a number of large insert jobs. In parallel with these, I am trying to run some updates against the same table. The rows being updated have a different feed_id to those being inserted, so there is no overlap between them. What I've noticed is that...
  18. Dagon

    For Loop Question

    This has probably been asked before, but searching for the word "for" is not the easiest thing... I have a simple for loop such as: for x in *.log do echo $x done This works fine except in the situation where there are no log file, in which case it returns the input criterion ("*.log")...
  19. Dagon

    Dynamic SQL and bulk bind

    Can someone confirm what I fear is the case. From Oracle 9 onwards, you can use dynamic SQL with bulk operations but for queries only i.e. you can do: index_by_table is table of something indexed by binary_integer; ... execute immediate 'sql-statement' bulk collect into index-by-table; But...
  20. Dagon

    Reference to a PL/SQL Variable

    Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit I'm trying to write a procedure in which there are a large number of input parameters passed as s type: type t_a is object (col1 varchar2(10), col2 number, col3 varchar2(50) ...); procedure find_obj(p_a in t_a) ... I have a database...

Part and Inventory Search

Back
Top