Recent content by connectxyzzy

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

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

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.

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

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)

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

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

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

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

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

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.

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

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

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

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