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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rk68

  1. rk68

    Data encryption in Oracle 19c

    Hi, I am using Oracle 19c Enterprise Edition Release 19 (without Advance Security license). If I go for Advance Security license, as per the Oracle website, it mentions that I will be able to encrypt the database or table columns etc. But I am still not clear on couple of things like- a)...
  2. rk68

    matching data from one excel sheet to another

    Thanks a ton Andy. It helped.
  3. rk68

    matching data from one excel sheet to another

    Thank you Andy & Combo. @Andy - there are no other rules. I had thought about what Combo mentioned but is more of a manual process and I don't want to do this as there are multiple worksheets where I need to do this. Hence was thinking of some function which could be used across the worksheets...
  4. rk68

    matching data from one excel sheet to another

    Hi, I have 2 excel sheet. I have to match value from 1st excel sheet to another excel using multiple keys 1st excel sheet type No. value CAR PETROL AB1 112 CAR GAS CC4 145 BUS GAS JY7 174 2nd excel sheet type No. value...
  5. rk68

    inserting multi lingual data

    Hi, I have table with a field with type NVARCHAR2. While trying to insert data into this field from PL/SQL developer, it store the value as inverted question mark (?). If I copy paste the multilingual data in the field, it store as it is & when I query, I can view the data. Its while inserting...
  6. rk68

    History log of all SQLs of a particular schema

    No Andy
  7. rk68

    History log of all SQLs of a particular schema

    Hi, I need to pull out log file for all the SQLs executed from 6th April - 13th April for a specific schema & table. I tried using DBA_HIST_ACTIVE_SESS_HISTORY / DBA_HIST_SQLTEXT but didn't find any data related to that table. The reason I require this log is a particular field was updated by...
  8. rk68

    Skipping blank rows while uploading thru SQLLDR

    Hi, We have user who upload CSV data thru portal & the same is inserted into oracle table thru SQLLDR. There are instances where the user uploads CSV file which has blank rows as well and these get inserted into the table. Is there a way to skip blank rows while using SQL loader. The CSV may...
  9. rk68

    Data fetch issue thru PL/SQL developer

    Thanks Johnerman. We re-started our database server & its working find now
  10. rk68

    Data fetch issue thru PL/SQL developer

    Hi Johnherman, Its nothing to do with the record retrieval limit on PL/SQL developer since we didn't make any changes in the settings. Since all the users are facing this problem, I don;t think its related to the record retrieval limit. Thanks for the reply. TIA, Raj
  11. rk68

    Data fetch issue thru PL/SQL developer

    Hi, We have been facing problem in Oracle while executing SQL queries from PL/SQL developer. Even if a simple select query with around 8000 records, data is only fetched for around 2000 records and then it shows as "Executing...." but no more records are fetched. We have to terminate by closing...
  12. rk68

    Duplicate records inserted

    Thanks Andy & Bill. I have applied UNIQUE index now & that's taken care. Since there are duplicate records & can't be deleted I created Unique Index with ENABLE NOVALIDATE. The max SR # is stored in a variable & then passed in the Insert sql.
  13. rk68

    Duplicate records inserted

    Hi Andy, the serial number is max + 1 at time of insert. Thanks Johnherman. The serial number as Andy rightly mentioned is picked from the same table with max no. + 1 and inserted along with rest of the fields. So in case where 2 users are submitting at same time , get the same serial no.
  14. rk68

    Duplicate records inserted

    Hi, We have a portal where multiple users upload transaction. A key Id is generated at time of insertion (e.g. FY20/JAN20/XXXXX) Key is Financial year FY20; month & year and XXXXX is a running serial no. by picking up max number + 1 if certain criteria is met else the Key Id is blank. At times...
  15. rk68

    moving the email templates from Excel to Word document

    I did manage it without VBA/macros. Thanks.
See more

Part and Inventory Search

Back
Top