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

  1. connectxyzzy

    Complex query without PL/SQL

    In the days before PL/SQL, we would code something like this (sometimes in a view....) 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...
  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

    As I recall, I've set up a Net8 listener and the tnsnames file had to be modified 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...
  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...
See more

Part and Inventory Search

Back
Top