Search results for query: *

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

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

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

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

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

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

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

Hi, I have a CSV file with around 475 characters. The field in the table PO_NARRATION is varchar2(200). I want only the 1st 200 characters to be inserted in the table. While trying to insert the data thru SQL Loader, I get the following error: >>> Record 1: Rejected - Error on table...

Hi, This is related to a website developed by our tech team, where in the user will be inserting text data using SQL Loader into the temporary table. Post this the data from temporary table needs to be inserted into live table with data validations (e.g. checks like field length, date format...

Hi, [highlight #FCE94F]98765,AB123,3;[/highlight][highlight #8AE234]98765,AD243,2;[/highlight][highlight #EF2929]98765,BG153,5;[/highlight] The above text data would have the following fields ID, SKU, QTY followed by ; There could be multiple records with all the 3 fields in a line with ...

Hi, I have varchar2 field in a table which has data in number/alpha numeric field. I want to extract records which has only numeric field with validation like the number should be between 1 & 10. The sample data is given below. A12 7 bb 5 4 c45 11 So out of the above 7 records, I need a query...

Hi, I have an address field (1 single field). I have pull out/insert in another fields certain text from the address fields matching to various criteria. e.g the address field are a) 88-C DGP House Prabhadevi Mumbai 400025 b) 405 Prathmesh Ashish Enclave Kanakia Santacruz Mumbai 400054 c) Plot #...

Hi, In one of PHP code, I have transaction data in MySQL. The data is validated in MySQL & then has to be inserted into Oracle table. I need to insert the entire data from MySQL to Oracle. How can I do it at one go. Is DBLink useful or can SQLLDR be used in PHP. TIA, Raj

Hi, I have a trigger which fires on change in certain fields & inserts the old field data in a history table. If the field has value (e.g.college name) & I replace it with null, a record is inserted with the member id in the history table but the old value (college name) is not inserted. This...

Hi, I have an excel sheet having data in the below format. City ID Product 1 Product 2 Product 3 MUM 1234 45 MUM 2345 65 12 MUM 3456 12 24 48 MUM 4567 12 MUM 5678 12 24 DEL 6789 48 36 DEL 7900 12 24 36 DEL 9011 36 DEL 10122 48 DEL 11233 60 The columns City & ID will remain. Product...

Hi, I have text data of around 1 million records. Is the data imported into oracle in the same order as in the text file. I'm using SQLLDR to import data. TIA, Raj