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 dencom 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: *

  • Users: etprash
  • Content: Threads
  • Order by date
  1. etprash

    db link not working from client sql developer but works from the sqlplus on db server

    I created a db link on our 11g RAC database. CREATE DATABASE LINK nst_test CONNECT TO eai_rt IDENTIFIED BY eai_rt USING 'EAIPREPROD'; When I try to use it from sql developer on my client machine in following way: select * from dual@nst_test; I get the error: ORA-12154: TNS:could not resolve the...
  2. etprash

    ora 06531: reference to uninitialized collection - after upgrd to 10G

    Hi, Recently we upgraded our database to 10G from 9i. We have been getting ORA 06531: Reference to uninitialized collection error in the new database. Some searches in metalink showed this is related to use of varray data type in the db packages. And the solution is initialize that type of...
  3. etprash

    Selection rows based on hierarchial preference

    Hi, I have a table with columns:status, gl_date and others. Status can take one of three values: CONFIRMED, REMITTED, CLEARED. My problem is that User wants to select record for a particular gl_date with preference. The order of preference is: 1.CONFIRMED 2.REMITTED 3.CLEARED If only REMITTED...
  4. etprash

    sorting two tabs together

    Hi friends, I have an excel file with data in two worksheets (identical data). Total number of rows exceeds 72k. I want to sort this data on one of the columns in one go. If anyone has solution/thoughts, pls do share. Regards, Prashant
  5. etprash

    spool vs utl_file

    Hi, Which is a better choice : spooling the file from sql plus OR using utl_file from pl/sql. Considerations - * load on CPU * Time I take it that from code development point of view, spool wins the race. Any input will be highly appreciated. Regards, Prashant
  6. etprash

    set sqlplus variable based on query

    Hi, I need to set a sqlplus variable using a query (since the value is stored in database). It would be something like this: define v_req_id = <select request_id from my_table> HOST uuencode '&v_req_id' a.txt|/usr/lib/sendmail <email id> Would it be possible. I tried using ACCEPT but was...

Part and Inventory Search

Back
Top