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

    Complex query without PL/SQL

    ...select sum(decode,team,'A',Position,0) Ateam, sum(decode,team,'B',Position,0) Bteam, sum(decode,team,'C',Position,0) Cteam From resultstab group by team,position having count(*) < 4 order by team,position Haven't tried it, but it should be close. Might bog down the DB if it's a huge table..
  2. connectxyzzy

    Update Query Help...

    Make the subquery a correlated subquery: UPDATE Agent TAB1 2> SET Agent.worktype = ( 3> SELECT DISTINCT tbl_Agent_List.worktype 4> FROM tbl_Agent_List -------> 5> WHERE...
  3. connectxyzzy

    ftp over modem

    Your Solaris machine may not allow FTP, just telnet. Typically both are allowed if either one is, but that may not be true here. Check with your Solaris admin.
  4. connectxyzzy

    Can Oracle 8.1.6 and Orale 7.3.4 co-exist

    ...to include the path to the 7.3.4 Oracle home. I am an old-timer used to editing the file directly, but I think there was an option in the Easy*config to allow for the wizard to configure an older version DB. BTW, if you have multiple versions running, always make sure of the environment...
  5. connectxyzzy

    Using SQL *Plus

    Folks, If you use 'set head off' in SQL*Plus or 'set pages 0'( that is a zero), both will eliminate headings. Also, make sure your local login.sql doesn't have these commands in there. (or glogin.sql)
  6. connectxyzzy

    Oracle Training

    Oracle offers training. You can tailor that training for your particular needs. Classes run fairly regularly across the country. No, I don't work for Oracle. There are several good books that can be found to start learning, and I'dcheck them out...
  7. connectxyzzy

    restore a dump from another system

    Just a WAG, but my bet is that you're running out of space somewhere. Run this query for grins: Select tablespace_name,bytes from dba_free_space order by 1 Thenrun: select tablespace_name, bytes from dba_data_files order by 1 if any tablespaces exist in the second list that had no entries...
  8. connectxyzzy

    can anybody give a solution for this ???

    How about a where clause? where (True=True and 104<=104) AND ( HP >= (50 * 1.15 / 1.15) and HP_Min < (80 * 1.15 / 1.15)) OR ( False = False and 107 > 104 and 149 <= 149) AND ( HP >=50 * 1.15 / 1.15 and HP_Min...
  9. connectxyzzy

    Substitution variables within cursors

    I think that you are using sql*plus substitution variable, and when you begin execution of that PL/SQL statement, the subs. occurs once because the entire PL/SQL statement is just executing once. If you re-run 'the entire PL/SQL' again, it would subs. once again. Just the way sql*plus 'sees' the...
  10. connectxyzzy

    Copying a package from one schema to another

    Couldn't you get the code out of all_source and run the resulting script under another schema (providing you have proper security)?
  11. connectxyzzy

    NTS Authentification ....

    I believe there is an init.ora parameter that needs to be set to allow remote logins, and the default is off/false for security reasons. I believe is is called remote_os_authent. There is a disclaimer in the documentation about the security implications. Hope this helps.
  12. connectxyzzy

    Tablespaces again please

    BTW, doesn't anyone use the SQL*Plus copy command anymore? With that DBlink, I think a copy works better, especially if copycommit is set to limit the potential for using up your rollback segment space...
  13. connectxyzzy

    Allow a user to change the WHERE clause via a form before script runs

    Um, what tool are you using? SQL*Plus has a prompt command, for example, that will allow you substitute whatever the result of the prompt is into the sql command. Other report generators have similar features, and you can custom-build a true form and then have the form call your reporting tool...
  14. connectxyzzy

    Sequence cache or nocache option

    Additionally, if you absolutely need sequential numbers from this sequence, don't cache. It will lose all the number in memory if you have a crash, and you will need to&nbsp;&nbsp;reset the sequence. (You could lose numbers if commits fail, but that is an app issue.)
  15. connectxyzzy

    oracle views

    If you want to discover if the result will be faster, run explain plan for 'select ......'<br><br>You may find the plan is identical, sometimes not. But the overall advantages of views usually outweigh the disadvantages (reuse of code, maintenance, clarity, security, granularity...
  16. connectxyzzy

    Testing To See If Oracle Instance Is Up On A Remote Server

    Perhaps establishing your second database as a standby, then pushing your archived logfiles across to the standby database from production would be a better alternative. You can make the prod database automatically synch the logfiles via your network (but I think that is only available through...
  17. connectxyzzy

    Terradata Platform

    To my knowledge, Teradata is a storage subsystem (usually high-end and expensive). If they are into other hardware such as servers, I am not sure.
  18. connectxyzzy

    List of "view" tables and List of Fields in a table

    ...you should get a list of the accessable tables that you can query for you to construct other queries. In particular, you can describe (in SQL*Plus) all_ind_columns, all_views (make sure the column 'TEXT' is long enough), all_tab_columns, etc.<br> <br> BTW, dictionary has two columns...
  19. connectxyzzy

    High Availbility

    I believe there is a product from Veritas that can help. I've just started researching for the same topic, and the name came up. Sorrry I cannot help further.
  20. connectxyzzy

    query that selects only the most recent record

    Select personid,etc<br> from persons outer<br> where seqnum=(select max(seqnum) <br> from persons inner<br> where inner.personid=outer.personid)<br> <br> This correlated subquery may be slooooowwwww if the table is quite large.....<br>

Part and Inventory Search

Back
Top