Recent content by CRoberts

Your syntax is off. Do you care tablespace? The follow should work: CREATE TABLE Test_Tab4 TABLESPACE TestTab_Ts STORAGE (INITIAL 500M NEXT 50M MAXEXTENTS UNLIMITED) AS SELECT * FROM ( SELECT * FROM Test_Tab1 UNION ALL SELECT * FROM Test_Tab2 UNION ALL...

The RegExp_Instr appear fine. This returns the position that a substring begins at. If not zero, add 1 otherwise add a 0. Try modifying the CASE statement: SELECT Username, SUM(CASE RegExp_Instr(Username, 'SYS') WHEN 0 THEN 0 ELSE 1 END) AS Tmp_Count FROM All_Users WHERE Username <>...

Oracle client installation can be surprisingly complex, but not really difficult once dealt with. Be consistent between the database and client platforms. So, if the client box is 64 bit then the Oracle client should be also. If the Oracle database is 10g then client should be be at least...

When dealing with dates, there are three things to to aware of. One is that a year is not constant, can be 365 or 366. Another thing to be aware of is time portion of a date. You want the date and time as of midnight or is any time okay? Lastly, is the Field1 part of an index? So, using...

To see the arguments of each function or procedure for a package just query the dictionary tables. I have report (do not run as SYS) that lists all the packages and their arguments for a schema that can be modified for just object: SELECT Obj.Object_Type, Arg.Package_Name AS Parent_Name...

I am working on large project with quite of number of Access databases located at remote sites where their Access databases are in an MBE format. These files are being sent to me and, I suspect, are in a variety of MS Access versions. What are the steps needed to convert these MBE back into...

Explicit join between an Xml Table and Path_View I have an xml table(content is immaterial at this point) holding a fair number of documents(100000+), but the doc contents do not explicitly have an element for "file Name" or "Path". (Which is just as well as documents can be copied from one...

Em is still, I think, a work in progress. Too many layers could be involved with an imp such that the true error is being obscured (see if a log was created). Sorting out the ports needed by 10g can be quite a problem if a port conflict has occurred. To simplify, I would shell out to the dos...

It is possible to create an array within a table. Never say never is rather strict, I would say that in some rare cases a VARRAY makes sense and can be quite convenient. If you anticipate referencing the elements of the array, then go with a relational table. But, if the list of numbers is...

I recently had a PC upgrade that went from Win2k to Xp with a similar upgrade in Access 2000 to Access 2002. I have a form for retriving various tips and techniques that I use by doing a string search within a Microsoft Rich Textbox Control, version 6. After the PC upgrade, string searchs no...

Sharing folders between Win2k, sp 2, and WinNt, sp6a. In a simple home network, 2 PCs, I am trying to set sharing so that both PC can read a folder of a similar name on both C drives. I can ping both ways between the PCs. After much work (and luck) I have got Winnt to map to a folder on Win2k...

Reading a book (Oracle Performance Tuning [an O'Reilly book], pg 427) tells of a sql script called Sync.sql. It explain on running this make little sense. Sync.sql is a file that is wrapped or encrypted. Yet the book tell of doing a &quot;EXECUTE SYNC.INIT&quot; like it was a existing stored...

I need to disable USB for Suse 8.2. During my new installation on Suse 8.2 I missed the the point where I need to disable the USB probing during initial boot up. There is an environment variable called HOTPLUG_START_USB that by default is set to &quot;yes&quot;. I need it to be...

Various ways to handle this. One way is to create a Package containing a Function (want Package persistance) that tries all formats until it finds the one that works and returns a date. Thus, no format mask need be used. Using this Function rather than TO_DATE by Sql*Loader is therefore more...

I was writting an anonymous PLSQL block to re-synchronize Sequences, sometimes Sequences get out of wack with their target tables. Fine, so I want to simply increment the sequence. But, neither Native Dynamic Sql nor DBMS_SQL approaches is working for me. Are Sequences excluded from being...