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

  • Users: rk68
  • Order by date
  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.
  16. rk68

    moving the email templates from Excel to Word document

    Hi Andy, I have attached a doc file FYR. It should something similar. If possible each of the column content can fall in separate page. Thanks, RAJhttps://files.engineering.com/getfile.aspx?folder=64514e51-01fe-491e-a9e8-53722f92b287&file=email_tmp.docx
  17. rk68

    moving the email templates from Excel to Word document

    Hi, I have multiple Email templates in Excel. These templates are in each column. I want this templates to be converted to Word document, so each template will fall in each page. for e.g. if there are 5 templates in 5 columns (Column A - E). Content of column A will page 1 of Word doc,content...
  18. rk68

    Display rows as column header

    Thanks Andy for the repy. LISTAGG did help to some extent.
  19. rk68

    Display rows as column header

    Hi, Below are data from the table. Campaign Code, Campaign Field, Campaign Field Description 1954, Field1, Mobile 1954, Field2, Email 1954, Field3, Name 2005, Field1, Website 2005, Field2, Mobile I want to display the field "Campaign Field Description" as Column header when a particular...
  20. rk68

    Hi, I'm executing the below proced

    Hi, I'm executing the below procedure from SQL command prompt. >execute pr_points_cal(9876543210,250,to_date('27-05-19 2:39:00 PM','dd-mm-yyyy HH:MI:SS AM'),789,987); Getting the following error; ORA-06550: line 2, column 7: PLS-00306: wrong number or types of arguments in call to...

Part and Inventory Search

Back
Top