The following link might be useful : http://jonathanlewis.wordpress.com/2006/12/14/constraints-inserts-and-bind/ Cheers, Norm. [TeamT] Norman Dunbar. Contract...
You can also use the following to generate xml.... SELECT XMLELEMENT ("rowset", XMLAGG (XMLELEMENT ("row", XMLELEMENT ("TABLE", table_name), XMLELEMENT...
Create a db-link to connect two databases. ... -- ÁÖ×ÓšJ ( Bruce Lin ) 0952077106 Create a db-link to connect two databases. 2007/1/29, Martin Gainty <...
it looks like the query is the issue try something like.. declare x as clob; begin SELECT XMLELEMENT("OuterTag", XMLAGG( XMLELEMENT ("InnerTag", t.col))) INTO...
... Toad for Oracle Suite 9.0.1 Trial Authorization Key: 0-07202-08774-06576-26210 This trial key is good for 30 days. It will provide you access to ...
You can try use DBMS_XMLQUERY package. For example: PROCEDURE getXMLData (sqlstr IN CLOB, xmlLOB IN OUT CLOB) IS queryCtx DBMS_XMLQuery.ctxtype; BEGIN queryCtx...
In v9, the menu structures changed quite a bit from previous versions so there is no longer a "DBA" menu. I believe the functionality you originally requested...
You're screenshot didn't work, but there is no DBA menu anymore. The menu layouts were reorganized for version 9.0. Most of what you're looking for is under...
Thanks for the reply. Unfortunately the "Database -> Compare -> Data" compare the data in one table.....we have 20+ in the database. I cannot go through the...
there is NO DBA menu anymore - you can only tell by looking at the about screen the reason was that some DBA stuff was under the DBA menu and some was not and...
Afternoon, ... Yes. Got to Databases->Compare->Schemas. Select schema a and schema b as desired - you can create a new connection by clicking the '...' button...
Norm he wants to compare the data within a table and not objects in a schema. I do not think there is a way to compare the data in multiple tables at the same ...
John, Ed, ... a schema. Ok, I'm going back to sleep. Wake me up when something happens please ... Note to self : Read the flipping posts properly before...
As one who as inherited databases like yourself I have a question for you which has a bet riding on it. Does that 400 column table have a meaningful comment on...
Patrick McGrath
Patrick.mcgrath@...
Feb 1, 2007 7:39 pm
35804
The only purpose for the wizard is to create a monstrous SQL statement that does a Select c1,c2,... from t1 Minus Select c1,c2,... from t2 Union Select...
Hi All, In Toad how to capitalize automatically oracle reserved words.? Regards, Rahul Chaudhari...
Rahul Chaudhari
rahulc@...
Feb 1, 2007 7:40 pm
35806
Thanks. I was beginning to think that nobody understands me (English is not my native language you know) :) :) So is there Any way , at all? Toad for MySQL...
Norman you are not the only one. My boss often prefixes his emails to me with "read all the words". Though he probably should change it to "read all the words...
Pravel's solution is very nice, In fact I might use it in the future. Here is another solution, but it has it's limits ... DECLARE xmlstr VARCHAR2 ( 4000 )...
TADA! Thank you, Roger, that's the ticket! Dan -- Dan Madvig Northwestern College & Radio, St. Paul, MN 651.631.5323 Note to self: Get procrastination...
Madvig, Daniel B
DBMadvig@...
Feb 1, 2007 7:41 pm
35810
THANK YOU! Dan -- Dan Madvig Northwestern College & Radio, St. Paul, MN 651.631.5323 Note to self: Get procrastination counseling ... tomorrow. ...
Madvig, Daniel B
DBMadvig@...
Feb 1, 2007 7:42 pm
35811
I installed the most recent version of Toad -- 9.0.1.8-- and I haven't had any problems with Toad getting hung to the point I've had to kill it since....
Wendy Penfold
wpenfold@...
Feb 1, 2007 7:44 pm
35812
I do not see anyway to do what you want in Toad for Oracle. You can ask for an enhancement request or just go through the wizard for each table. I did...
No comments on the table at all. At least the field names represent what the totals are. It was designed as just a place to "dump everything in case we need it...
I upgraded to the latest version of TOAD (9.0.1.8) and noticed that the results of the explain plan are very different than in 8.6.1 Is there any way to...
if your problem with it is that it's too tall vertically, right-click and choose "adjust content". Then check "as column" for cost, bytes, and cardinatlity. ...
I support inclusion of classic explain plan, but for one reason only, which is giving presentations or teaching how to read explain plan. The old classic look...
Thanks, that helps. I preferred seeing the Cost as a column. I just needed to learn how to use the new features I guess. ... click and choose "adjust content"....
If you are on Toad 9, goto Options->Editor->Behavior and select PLSQL in the language list box. Edit the PLSQL language and goto the Highlighting tab. There...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
