Recent content by rk68

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)...

Thanks a ton Andy. It helped.

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...

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...

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...

No Andy

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...

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...

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

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

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...

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.

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.

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...

I did manage it without VBA/macros. Thanks.