Recent content by shayt

hi, i used the method that suggested in a previous post - post regarding - how to run script in a real sqlplus session (and not run in a command window). but there is a bug ! in the command window, if i load a file to the "EDITOR" window, and this file has spaces in the name ! and then...

wow !!! very cool. thanks.

hi, i am using version 7.0.2.1076. if i have a script in a SQL window, i would like to run this script in a REAL SQLPLUS session. currently the only reason i am still using TOAD (and PLSQL Developer for other things) , is for this feature !!! because in my company, the script we are making...

hi, i am using version 7.0.2.1076. when i do extract DDL on a table, 1. i would like to get the DDL of the triggers on this table also. 2. i would like a check-box if i want or don't want, to put the schema prefix before the object. thanks, Shay

OK, i sent the file to the support email. Shay

hi, my table : table_with_clob has some columns, one of them is CLOB. in one DB (only one ! ) when i do select * from table_with_clob; in PLSQL 7.0.1.1066, the transaction hang. but in TOAD, SQLPLUS it's OK. i tried to do the same thing in a different DB, and strange - it works in PLSQL...

any news on this bug ? when it should be fixed ? Thanks, Shay

sure - 1. create table tmp_s_1 (a number, b number, c number) 2. insert the following data in XLS - a b c 1 2 3 4 5 6 7 8 9 3. Go to "Text Importer", copy the XLS cells, and paste the clipboard to "Data From TextFile" tab 4. Go to "Data To Oracle" tab in the "Text Importer" fill the owner...

sorry, the problem is NOT in .SQL files. it is in .PRC files i have a test1.prc file that contains - CREATE OR REPLACE PROCEDURE xxx ... / CREATE PUBLIC SYNONYM xxx FOR xxx / GRANT EXECUTE ON xxx TO USER_ALL_OBJECTS / and when i load it to the SQL window, each command is in a seperate tab. but...

ok about the highlight... i am talking about - if i stand on "(" and press "Find Matches" the program go to the matching ")" but now it is not working. Shay

Hi, if i have a file, with multiple queries : select ... / select ... / when i load the file to a SQL window, i am getting each query in a different tab (that's great). but when i save the file, the last "/" is deleted. so the file becomes - select ... / select ... so i need to insert the last...

Hi, the "Find Matches" doesn't work in Version 7.0.1.1066. not using the short-cut and not using the menu. Thanks, Shay

the (very good) Text Importer, has a bug in Version 7.0.1.1066. the script i am getting consist the record type INSIDE the name, so i getting an error, because the name is not good, example for a script produced by the text importer : insert into xxx.yyy (CUSTOMER_ID__NUMBER_...

Hi, i am using PLSQL Version 6.0.6.947 and i am using XMLTYPE all the time (so i need this bug to be fixed !) if i am trying to run this query, the session hung, i am not getting my results, and i cannot stop the session. the query - SELECT XMLELEMENT("MY_ROOT", xmlattributes...

about #5 - this is not what i ment, i want to run ALL the commands in one time (as script), so this is why i seperate each of them with ";" or "/". i want to mark all the relevant lines, click F8, and all the commands will be executed. of course i am not talking about SELECT command, in the...