Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HimanB

    Formatting Execl output using OLE2

    Hi, Please refer to Note:1011625.7 at metalink. You need to create a macro & call this macro within your Program from the Form. Regards Himanshu
  2. HimanB

    Simple Master-Detail question

    Hi, On your Key - create record trigger write: Last_record; Create_record; Regards Himanshu
  3. HimanB

    Populate List

    Hi, Whatever code you have written to Populate the Sec name list, write it again on the the trigger when-list-changed of List item deptname & add the where clause to it accordingly. i.e. when deptcd=:blockname.deptcd. HTH Regards Himanshu
  4. HimanB

    Cursor too Slow ,Select is fast

    Yes Sem, Both were launched by same user, which also happens to be the owner of all the objects used in both Processes. Yes Sbix, the this is funny & I have no answer to it,why this is happening. I have given the workaround to my team and the process is running fine but I am keen to find out...
  5. HimanB

    Cursor too Slow ,Select is fast

    Dear Sbix, There is no contetnion of temp tablespace. Sorry for confusing post,by temp table I mean a Database table only which I named as temp. Also please go through the post carefully,I am facing the problem when we use cursors. Do let me know if you have any idea about it. Regards Himanshu
  6. HimanB

    Cursor too Slow ,Select is fast

    Dima, We have tried both TEXT_IO from forms & UTL_FILE from stored procedures. I repeat once again that there is no problem with writing of CSV file. Once the data is populated in the Temp table(as we are currently doing) it takes less than a second to write the file. By using insert into temp...
  7. HimanB

    Comparison of tables

    SDMY, Again there is a syntax error in your code. Instead of writing FILEHANDLER:=UTL_FILE.FOPEN(L_DIR||abc.sql,'W'); You are supposed to write FILEHANDLER:=UTL_FILE.FOPEN(L_DIR,'abc.sql','W'); Also please ensure that directory 'c:/sample' exist for the utl_file parmaeter in your DB...
  8. HimanB

    Cursor too Slow ,Select is fast

    Dima, Thanks for the valuable input. I have traced both the sql's & both of them have same execution plan.The only difference in case of PL/SQL you have context switching which is not very high. Both the SQL's used on SQL prompt as well as in Cursor are same & there in no datatype difference...
  9. HimanB

    Cursor too Slow ,Select is fast

    Dear All, My team is facing a problem. They have made a stored procedure which fetches data in to a Cursor and then writes it into a CSV file. The query has been checked & it is fully optimized. When executed on sql prompt it fetches data in milliseconds. The query uses UNION ALL clause & has...
  10. HimanB

    Comparison of tables

    Hi sdmy , As you have not implemented the code the way I have written it it is giving you errors. Your code L_FINAL_STR:=' SELECT L_SQL_TEXT FROM ((SELECT L_SQL_TEXT FROM I.rst MINUS SELECT L_SQL_TEXT FROM I.cst@Link2 UNION (SELECT L_SQL_TEXT...
  11. HimanB

    Comparison of tables

    Hi, In order to create a script for your self for each table you can simply run the following procedure. Chnage the YTL_DIR path as per the settings of your database. create or replace procedure myseq is CURSOR C1 IS SELECT TABLE_NAME FROM USER_TABLES; Cursor First_Table_Cur(P_TAB VARCHAR2)...
  12. HimanB

    Cross database query

    Hi, You would require a Database link between the two databases. and then issue the query from target db to source db(e.g. dbn200): create table a as select * from from schemaname.tablename@datbaselinkname; HTH Regards Himanshu
  13. HimanB

    Oracle Date Pocker

    Hi, Please refer to Note:95518.1 at Metalink. HTH Regards Himanshu
  14. HimanB

    what is alternative to sp_help in oracle

    Hi, You can get your Stored Procedure & Functions's Text from view USER_SOURCE or DBA_SOURCE or ALL_SOURCE. Select Text from user_source where NAME ='MY_PROC'; HTH Regards Himanshu
  15. HimanB

    Round off problem

    Hi, Tyb I do not see any problem with this. Check what is the formula you have written for calculation. Check if the 2nd item which has value of 66.67 is rounded off to 67 otherwise the result should be perefect. You may chek by running followin query also on sql prompt. SQL> select...
  16. HimanB

    Run Non oracle application

    Hi, You may use ORA_FFI or DDE package to run any external application or Program. HTH Regards Himanshu
  17. HimanB

    How Make *.exe file of software .

    Hi, Make use of Project Builder to make installable file for your application. HTH Regards Himanshu
  18. HimanB

    FROM emp SAMPLE ( MYNUMBER )

    Hi, This code will not work if you use a Bind variable instead of a harcoded value. If you wish to use a Varibale then declare the cursor , open it & then use the values fetched by the cursor. HTH Regards Himanshu
  19. HimanB

    SET_CANVAS_PROPERTY TOPMOST_TAB_PAGE

    Hi, Hudo, please read through the Online help thoroughly. It has following Options: SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, value VARCHAR2); SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, x NUMBER); SET_CANVAS_PROPERTY (canvas_id...
  20. HimanB

    SET_CANVAS_PROPERTY TOPMOST_TAB_PAGE

    Hi, Hudo, please read through the Online help thoroughly. It has following Options: SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, value VARCHAR2); SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, x NUMBER); SET_CANVAS_PROPERTY (canvas_id...

Part and Inventory Search

Back
Top