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: *

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

    USER_OBJECTS

    I may have a solution to your problem. It is simply the way SQL*Plus displays columns. It has to do with what the SET LINESIZE n is set to. Numbers are limited to NUMBER(38) so your Object_ID will be displayed. However, if a text column, like Object_Name is displayed, you can get '--- ...'...
  17. CRoberts

    Help with Query Performance

    Tough problem. You have no access to explain plan, no way to know if any, or what, indexes are being used? Some simple suggestions, may or may not work, depends on the database. 1) Use ORDER BY 4 to sort your results, or select Mandated and order by on it. The ORDER BY can be used by...
  18. CRoberts

    date format conversion

    Oracle has a very robust set of date/time functions. The database has various defaults like dd-Mon-yy for a date. You can change from the default via using a function (like TO_CHAR or TO_DATE) or alter the session using an ALTER SESSION Looks like here you want something like (from Oracle's...
  19. CRoberts

    SUBSTR Question

    GROUP BY is a clause, not a function. This Clause is used when you are applying an action against a set of records like SUM, COUNT, AVG or some other like function. Said another way, use GROUP BY with any Group function. Do not use GROUP BY with a Single-Row Character function like SUBSTR...
  20. CRoberts

    Trivial Question Concerning Quicken and Oracle

    I know nothing about Quicken, but I believe that it should not be much different than Excel or MSWord, if Quicken uses ODBC. If Quicken does, then the necessary ODBC filters must be added from the MS Office (I believe the default installation is not to add them) Suite CDs. Then you can use...

Part and Inventory Search

Back
Top