I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in tha...
There are many options for editing and writing Stored Procedures in Oracle; what is the best tool for you and why? (one tool per answer.) ...
I am a big fan of the light colors on a dark background color scheme for programming - which is unfortunately not what Quest's Toad comes with by default. I notice that it is possible to export and import settings under the language management window, and I know that Toad has a large level of community involvement. So I assume there...
In toad, I can see unicode characters that are coming from oracle db. But when I click one of the fields in the data grid into the edit mode, the unicode characters are converted to meaningless symbols, but this is not the big issue. While editing this field, the unicode characters are displayed correctly as I type. But as soon as I pre...
Using toad and an oracle database, how can I call a sp and see the results by passing an array to one of the parameters of the sp? ...
I realize that in of TOAD books right, it justifies the reaons on why it uses tabbed pane is that tree view involves too much scrolling. But for me i like tree view better. As it only shows you the top level. I see TOAD user interface. i thought the tabbed panels was very confusing for me to switch around. What are your opinions regard...
Anyone have any idea? And any open source sofware which also seens to perform this kind of functionality? ...
Anyone have any idea? And any open source sofware which also seens to perform this kind of functionality? ...
Anyone have any idea? And any open source sofware which also seens to perform this kind of functionality? ...
Hi, I'm currently generating SQL insert statements from more than one tables, and in the generated data I need to use a CASE statement, like this: select 'INSERT INTO TABLE1 (f1, f2, f3, f4 ...) values (' ||t.f1||',' ||CASE WHEN t.f2 > 0 THEN '1' ELSE '0' END CASE from table2 t , table...
Anyone knows how to do that? I can currently go to Tools|SGA Trace/optimization. to check the currently executed SQL. But i want toad to be able to send me daily. I think can use windows schedule task to achieve that . But how exactly to go about that anyone knows? Will be good if anyone can also suggest if it is possible to also have a...
Hi, does anyone have any experience using both of these products and willing to share some pros and cons of each? I love TOAD but I'm moving to Mac, so I'll have to give it away. I can always run TOAD in a VM, but at the same time I'd like to try something new and native to Mac OS. Toad is a memory hog and crashes constantly, so if I co...
Semi-regularly when using TOAD, I will try to connect to a DB and get the error "ORA-12638 Credential retrieval failed". I have to restart my TOAD to get past this. It's a pain if I have other connections active. Does anyone know how to avoid or get around this error? Thanks ...
Simple question, would love a solution if there is one! I assume there has to be some keyboard shortcut that will insert a null but Google isn't helping. Thanks in advance! ...
I have created two identical tables which list all the exceptions with regards to certain rules of products in the data base. table one is for week 1 table two is for week two the exception are just view on a weekly basis and no correction is made in the data base. week twos data includes the exceptions in week one i want to exclude week...
I have always used TOAD by Quest to do my development and administration work in Oracle and MS SQL Server. However, I am trying not to be myopic in my choices. Are there other tools that you would recommend that will allow me to connect to the database(s) and perform my development and administrative duties? ...
Hi guys, I'm just looking for a management tool like TOAD for Postgres. Anyone used a good one? Edit - I work mostly within the data itself and the database already has a mature model/design. I use the edit windows the most (well, in TOAD for Oracle anyway.) As far as I know, Toad only exists naturally for: Oracle, MS SQL, DB2 and My...
Are there any better alternatives to using SQL Tools and TOAD for writing stored procs and queries for Oracle DB? Better in the sense of being able to debugg large queries and stored procedures. Any pointers are welcome! ...
I am able to connect to an Oracle database using several tools, but am unable to connect using Toad for Oracle 8.5.3 (though before a login/logout to Windows I was able to). I am not using TNSNAMES.ORA to connect. I have two Oracle homes: C:\Oracle\product\10.2.0\client_1 (OraClient10g_home1) and C:\Oracle\product\10.2.0\client_...
What does the warning mean? Why is the second example worse than the first? SELECT product_id, prod.name name, sample_id FROM lims.sample JOIN lims.product prod USING (product_id) vs. SELECT product_id, prod.name name, sample_id FROM (SELECT sample_id, product_id FROM lims.sample) JOIN lims.product prod /* ADV...