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 strongm 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: AJCG
  • Order by date
  1. AJCG

    XML Data newbee

    Output I would like into an Oracle DB - Normal table (This is an external data feed btw)
    • AJCG
    • Post #5
    • Forum: XML
  2. AJCG

    XML Data newbee

    Hi Update for you... I have now created a new xsl file (not quite working yet..) <?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:template match="/"> <html> <body> <h2>CD Collection</h2> <table border="1">...
    • AJCG
    • Post #2
    • Forum: XML
  3. AJCG

    XML Data newbee

    Hi, I have just been given some xml and I need to create a HTML page which access the data. This is where I have hit a big old snag. First off tho please note I have never touched XML data before so I know very little. The XML data I have does not seem to have an xsl stylesheet and I think...
    • AJCG
    • Thread
    • Replies: 5
    • Forum: XML
  4. AJCG

    Forms Internet Link in Text Box

    Is there a way of making a link in a forms text box excecutable? I.E. Clickable?
  5. AJCG

    Indexing Question

    Hi again, just me... OK Too the first poster here (nbateman) Yep I know been doing that one for a few years, just getting lazy I suppose and trying to find a way round it.... v$object_usage yep been using that too to keep an eye on a few indexes.. Removed six useless ones so far.... Thanks...
  6. AJCG

    Indexing Question

    I have a few tables, and a few indexes.... I remember an Oracle tool for checking out indexes and giving you a report on whether they are useful, and giving you suggestions on additional ones.... Anyone think of another program for this?
  7. AJCG

    Need help with UTL_FILE (URGENT)

    What Has this to do with Utl_file.... I get the feeling thats the question I need answering... I am using utl to update individual clients contact data and I am unsure of how to get rid of the double quotes... I get an ORA-01858: a non-numeric character was found where a numeric was expected...
  8. AJCG

    Need help with UTL_FILE (URGENT)

    I have a large update file sent back to me from an external agency, would like this file to update a suppression table very simple... But the file contains &quot; arround all values i.e. &quot;58153021&quot;,&quot;9009774&quot; Without using sed in unix I would like the procedure to strip...
  9. AJCG

    getting ORA 1092 when trying to manually create a database...

    getting ORA 1092 when trying to manually create a database... NT, Oracle 9i.... God knows why but here's a copy of my create script.. create database REPACG controlfile reuse datafile 'D:\oradata\REPACG\control01.ctl' size 250 M reuse, 'D:\oradata\REPACG\control02.ctl' size 250 M reuse...
  10. AJCG

    Clear a veriable &amp;&amp;Bytes

    Thanks that worked!!! I feel stupid!
  11. AJCG

    Clear a veriable &amp;&amp;Bytes

    Hi, I have written the smallest sql query in the world just to give me file size, but once I have defined &&bytes every time I run in again I am unable to redifine it? select sum(&&Bytes/1024/1024) from dual; Enter value for bytes: 65945600 SUM(65945600/1024/1024) -----------------------...
  12. AJCG

    Forms Active bar

    Hi All, I thought this would be obvious but I can't find it... I am creating a form in forms 6i, and I want a little bar down at the bottom which just shows its active, you know something graphically going back and forth.... Any ideas? Adam
  13. AJCG

    select emp_num from emp SAMPLE(20);

    Ermm I think I may have communicated the wrong issue? I was asking about selecting a random set of rows from 800000 returned from the original query...? The query on the other hand is ruynning very fast anyway? But thanks for the suggestions! Regards Adam
  14. AJCG

    select emp_num from emp SAMPLE(20);

    All, I wonder if you can be some help, the above query returns a random 20% of the table emp.. I would like to beef this up to return a random 20000 rows (845000 in the table) from another table (clients) after I have already done a set of filters in the sql statement i.e. select * from...
  15. AJCG

    Oracle DBA - 15 Mths

    Thanks for your reply.... Adam
  16. AJCG

    Oracle DBA - 15 Mths

    All, I have been an oracle dba for 15 mths and since I left my last position the inustry has died a death in England... I am currently a 'CRM DBA' ('yuk!') which means I have no Hardware interaction and spend most of my time in meetings... This is not my idea of fun? Any ideas about good...
  17. AJCG

    Oracle DBA - 15 Mths

    All, I have been an oracle dba for 15 mths and since I left my last position the inustry has died a death in England... I am currently a 'CRM DBA' ('yuk!') which means I have no Hardware interaction and spend most of my time in meetings... This is not my idea of fun? Any ideas about good...
  18. AJCG

    Email Addresses

    I have made a few alterations to my procedure and cut the name part of the email address and the domain information into seperate variables, I am then splitting down the domain info... This is still an issue I am having trouble with...
  19. AJCG

    Email Addresses

    Hi Again... I have tried a different tack but I am still getting problems namely with end of lines... say I do this : v_part_third := INSTR (v_email_sec, '.', 1, 1); v_part_fourth := INSTR (v_email_sec, '.', 1, 2); v_part_fifth := INSTR (v_email_sec, '.', 1, 3)...
  20. AJCG

    Email Addresses

    All, I have been having trouble doing soomething that sounds easy but is turning out to be quite difficult, i will explain:- I have a table with a lot of emails in it like say - blah@someone.com b.23l@a207.navy.com.au adam.chris-gran@ca.co.uk and so on, I would now like to split these down...

Part and Inventory Search

Back
Top