Using Toad 9.7.2 against a network Oracle DB (10g) I can't see any objects in the schema browser using the account information provided to me by my DBA. Using Oracle 10g installed locally, I see all objects in my local Oracle instance using the account I created which has all privileges. I believe this is an instance where the account p...
We are evaluating trial versions of Red Gate’s SQL Toolbelt and Quest Software’s Toad for SQL Server. What are the main differences between these tools? The benefits of using these tools are quite obvious but we are wondering which one is more suitable for a developer and development work? Is Toad for SQL Server more focused on DBA work?...
Hello! We have a lot of our business logic in an oracle database. So we use a lot of PL/SQL code. We build, test, and debug PL/SQL packages, procedures, triggers, and functions. Our current tool is the PL/SQL Developer (http://www.allroundautomations.com/). What are your tools for PL/SQL coding and why do you prefer it to the PL/SQL De...
Yesterday I read something abouth application optimization and how a programmer should find the most used parts of the program and by profiling and modifying them getting the most benefit (when looking at the time/work invested vs. memory/speed gains). Now, I've run the Eclipse profiler, got VisualVM but I don't how to use this data prop...
For fun I been playing with the built-in Optimizer for Oracle in Toad today. One of the optimizations it suggests is the following AND emp.pay_type = NVL('FT', UID) Instead of AND emp.pay_type = 'FT' I'm confused on what is happening here and because of it, confused on also on why this would improve performance. Since FT is a strin...
Hello. I have oracle dump file from Oracle8. I am trying to import data in Oracle 10. For importing data I am using PL/SQL Developer(buy the way, I have TOAD client). I am doing that by click Tools->Import Tables choose Oracle Import, and then choose Import file. after that click Ok, Done. so How I can find imported tables? I am using "s...
I'm just learning Oracle and I understand the concept of triggers and sequences. What I can't seem to find is how they are used together in an auto-increment fashion similar to a SqlServer Identity setting. In a really simple example, I have a table called Employees that has three fields (all required): EmployeeID (PK), FirstName, LastNa...