Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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")...

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

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