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!

  • Congratulations SkipVought 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. ociruj

    SRW.USER_EXIT

    Hi, im a newbie in oracle applications. i understood that srw.user_exit is used for multi-org co, so the report will fetch records from the organization. am i right? but, how will i know what organization does this call? or pass through my report. how will i pass this to get the description of...
  2. ociruj

    difference between bitmap and character mode

    hi there, i just want to ask the difference between bitmap and character mode. thanks.
  3. ociruj

    Problem w/Personal Oracle 8i and Forms 6i

    Hi, i installed personal 8i and forms/reports 6i on my pc... the problem is, when i try to connect to d database through forms/reports... an error occurred : TNS:could not resolve service name.. but when i tested the user using easy config, connection is successful, what should i do?
  4. ociruj

    ora-02085 - database link connection error

    hi,, i tried created a database link and it was successfully created.. but when i was trying to access the link.. ora-02085 appears.. what should i do? tnx for ur help..
  5. ociruj

    oracle graphics

    hi, i have a question in oracle graphics... how do i pass a parameter from oracle reports to oracle graphics? any help is appreciated.. regards...
  6. ociruj

    convert table from ms access to oracle

    hi everybody, just wanna ask, how can i convert tables from ms access to oracle... how do we carry the data structure of the tables going to oracle.. thanks..
  7. ociruj

    first day of the month

    Thanks DIMA for your help.... Regards...
  8. ociruj

    first day of the month

    hi there, how can i get the first day of a month? is there a function for that..?
  9. ociruj

    PL/SQL - ORA-06502 Error

    Hi, may i see ur script?
  10. ociruj

    SQL between two tables

    hi, it should be: select a.wonum from workorder a where a.ACTLABCOST IN (select sum(labtrans.linecost) from labtrans group by labtrans.wonum where labtrans.wonum = a.wonum)
  11. ociruj

    Creating Stroed Proc error

    hi, &quot;select ROW_COUNT from DLETBLID where TABLE_NAME = sTable;&quot; should be: select ROW_COUNT into <VARIABLE> from DLETBLID where TABLE_NAME = sTable; regards
  12. ociruj

    import/export data into/from oracle database

    thanks mr. martin, ur right this is what i needed.... actually it will be used in forms... so the user does not need to use pl/sql.. can u give me an example of importing text delimited file using text_io?? thanks again and regards...
  13. ociruj

    search and replace with in a field

    hello, you can try: update <table_name> set <column_name> = replace(<column_name>, &quot;test&quot;, &quot;<ip address>&quot; ... hope this helps... regards
  14. ociruj

    import/export data into/from oracle database

    thank you for your suggestion.... but what i need is to use text.io..... how do i do it.... please help me... thanks again...
  15. ociruj

    import/export data into/from oracle database

    thanks for the reply Turkbear... its the same thing.... import from text delimited file and/or export from oracle to text file... regards..
  16. ociruj

    selecting all columns

    hi, u can use select *, ltrim(col,'0') from _____ i just cant remember if this will work... but u can try,... regards..
  17. ociruj

    import/export data into/from oracle database

    hi, i want to import/export data into/from oracle database. how will i do this using i think text.io or text_io... please give me sample code... thanks....
  18. ociruj

    Help with Concatenation..

    hi.. ope this may be of help... v_Terms_Str := rpad(v_Terms_Str, 15) || ', ' || TermRec.Term_Nm
  19. ociruj

    Front-end advice

    hi, you can use Oracle Forms and Reports Developer... Gud Day!!!
  20. ociruj

    Using Hint in Stored Procedure

    try this... /*select statement using index idx1_contract_search*/ SELECT DISTINCT t1.seq_prov_id,t2.line_of_business, to_number(t3.contract_search_type),t2.panel_id, t2.ipa_id,t2.pcp_flag FROM master t1,contract t2,contract_search t3 did i get ur question right...?

Part and Inventory Search

Back
Top