I have extracted data from Oracle logminer and I need to convert this into useable SQL.
SQL_REDO from logminer:
insert into "UNKNOWN"."OBJ# 74587"("COL 1","COL 2","COL 3","COL 4","COL 5","COL 6","COL 7","COL 8","COL 9")
values (HEXTORAW('c12d'),HEXTORAW('c4032c362e'),HEXTORAW('c3042222'),HEXTORAW('c105'),HEXTORAW('c3394c44'),HEXTORAW('c108'),HEXTORAW('c108'),HEXTORAW('c109'),HEXTORAW('c10b'));
Required Value:
Insert Into Scott.Test_Table
Select 44,2435345,33333,4.1234,567567,6.766,7,8,10 From Dual;
So I need help with the conversion from the Hex value to the actual value, this is for all data types.
for example:
c12d = 44
c4032c362e = 2435345
etc
A copy of the log from v$logminer_content is in SQL Server
The resulting code should be one of the following:
1) SQL Server Function to convert the SQL
2) c# code
3) Python Code
The oracle database is using the default character set of AL32UTF8.
Please note I do not want to used the online dictionary from oracle, the overhead is too high.
Thanks
Hi there,
please leave a message on my chat so we can discuss the budget and deadline of the project. I have read your project description and i'm confident i can do this project for you perfectly. Thanks
.
.
Hello there, How are you doing?
I have read the description, I have great experience doing similar jobs related to these skills Database Programming, Microsoft SQL Server, Oracle, Python, SQL.
Right now I am placing a place holder bid, We will decide the price and time after discussion. Please start the chat so we can have detailed discussion. Thanks
Hi
I have relevant skills regarding Oralce Encryption Using TDE and Decryption Protocols i can handle this data from Logminor Please send me message to discuss this in details
Thanks
Adeel
Dear Employer (can do the job for even less)
I have extensive experience Oracle SQL and Python. I can do the conversion from your default character set to your favourite format. Please let me know if you are interested and I would be more than happy to assist you.
Mike
Hello!
Me and my team can deliver your tasks with great quality
We are working on hourly rate 40usd / hour.
Please check my profile and message me for more details.
Thank you.
Hello There. How are you doing?
I have read the description, I have great experience doing similar jobs related to these skills Database Programming, Microsoft SQL Server, Oracle, Python, SQL. Please start the chat so we can have detailed discussion. Thanks
Hello, How are you?
I'm very interested in your job post.I believe my skills would be ideal for your project.
I am Python Expert and I have rich experience with sql and I can help you perfectly.
And then I am a good english speaker.
So anytime,anywhere you will discuss anything with me freely.
My wonderful service will give you pleasure and happiness.
I hope you will contact with me and work together.
Best Regards..
Hi, i am a enthusiastic freelancer and i am doing this work from 5 years, I had read your requirements and can handle your project please message me so we can discuss more.
Thanks
Dear Project Manager
I am having around 9 years experience, working full time as oracle developer. I have the right skill set to perform your task.
As per my understanding, the task involves inserting the values obtained from logminer into executable Oracle insert script. I believe I can do this task within 1 day.
Thanks & Regards,
Banani
Hi !
Greetings! I have gone through your project requirements and interested to do this job as my skills and work experience match your requirements.
I am ready to do small sample so that we can share same understanding over the required results.
I will look forward for your response.
My skills:-
1. SSIS (SQL Server Integration Services).
2. T-SQL (Transact Structures Query Language)
3. Data Analysis
4. Report Development
5. Linux
6. SQL
7. System Admin
8. PostgreSQL
9. Microsoft SQL Server
10. Database Development
11. Data Warehousing
12. Data Visualization
13. Database Administration
14. Software Testing
15. Tableau
Best Regards,
Sanju Gupta
