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!

Recent content by CRoberts

  1. CRoberts

    Union all to create new table trouble, "missing key word"

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

    sum(case when regexp_instr(...)

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

    Oracle Client Help

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

    SQL code to check for records 365 prior to today

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

    Getting Package Parameters via SQL Command

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

    Extracting data from MBE

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

    Explicit join between an Xml Table and Path_View

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

    Host Credentials on NT Box ( XP )

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

    Declaring arrays ....

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

    RichTextBox controlo no longer allows searches.

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

    Sharing folders between Win2k, sp 2

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

    Reading a book (Oracle Performance

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

    Disable USB in Suse 8.2

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

    sqlloader help

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

    Does DMBS_SQL (and EXECUTE IMMEDIATE) not work with Sequences?

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

Part and Inventory Search

Back
Top