Search results for query: *

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.

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

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

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

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

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

Hi, My Shiny Server is cloud based. How do I connect to Oracle database server. I have the same Shiny setup locally on my system & I can connect it to Oracle. But while trying to do the same thru Shiny cloud setup its not connecting. How can I resolve this. TIA, Raj