86 Blog Posts To Learn About Oracle

Oracle refers to a major relational database management system often used for enterprise-level applications. It matters for its robust capabilities in handling large-scale data, ensuring high availability, and supporting complex business operations.

1. How to Migrate from Oracle to PostgreSQL

This article explores the most important challenges and solutions of the database migration from Oracle to PostgreSQL.

2. 4 Decentralized Oracle Platforms that Bridge Real-World Data to the Blockchain

Here's a look at some four differrent blockchain oracle platforms.

3. 10 Best Online Courses to Learn Oracle and PL/SQL for Beginners

4. Types Of Medical Databases And Their Benefits For Humanity

What are medical databases?Medical Databases serve as an essential part in medical care, which includes the disciplines of research, documentation, patient care and treatment. The medical industry is constantly on the lookout for new medical applications, which would help improve their services. These endeavors are usually done through databases, which store data regarding diseases, diagnosis, treatments, medication, medical devices, medical practices and other pertinent details about medical professionals. With the constant advancements made in technology, these databases have also grown to be more technologically advanced and complex.

5. A Quick Tutorial on Using SQL Expressions for Validation in Oracle APEX

Learn how to use SQL expressions for validation in Oracle APEX with our quick tutorial. Explore step-by-step instructions and practical examples.

6. Oracle, IBM, or Open JDK? How to Know Java Vendor Details

A simple java command that will provide us the vendor details describing what vendors java implementation has been installed on that particular server.

7. Saving Dataframes into Oracle Database with Python

Here are two common errors that you'll want to watch out for when using the to_sql method to save a data frame into an Oracle database.

8. World’s Worst Tech Employers

Today I am going to talk about tech companies that are most famous for being hated by many people and having a bad reputation.

9. Creating a Branch Process in Oracle Apex

In Oracle Apex, we create a Branch Process to open another page after submitting the current page. Because a Branch process executes on the page submit.

10. A Brief Introduction to Oracle Apex: Features, Advantages, and Use Cases

This tutorial provides an in-depth overview of Oracle Apex, including its features, advantages, and use cases. It covers the benefits of low-code development...

11. How to Modify Private Network Information in Oracle Clusterware 19c

How to Modify Private Network Information in Oracle Clusterware 19c.

12. Exploring PL/SQL Nested Tables in Oracle

In this tutorial, you will learn how to declare and initialize Oracle PL/SQL collections (Nested Tables).

13. Playing With Oracle ASM and Multipath Disks - Configuring the ISCSI and the ASM Disks

Configuring Oracle ASM disks using iSCSI and mulipath.

14. Blockchain Trading Platform Morpher Releases Open Source Data Oracle

Morpher unveils open source data oracle for accurate, multi-source, and real time market data; a first for blockchain.

15. Should Regulators License Blockchain Oracles?

Blockchain oracles, or off-chain data providers, are key players in the blockchain ecosystem - wielding as much if not more power than miners and protocols developers. Often misunderstood and overlooked, they suffer from constant misuse and security vulnerabilities. Licensing and endorsing professional oracles is key to improving the overall health of the blockchain ecosystem.

16. Migrating From Oracle Forms to APEX? I’ve Done it and Here’s Why I Think You Should Too

What is the matter with Forms’ support? Why migrate to APEX? What are the benefits? In this article, I’ll provide you with answers to these questions.

17. How to Pass the Oracle Certified Java Developer Certification OCP 11 Exam

My favorite books, courses, and practice tests you need to prepare well for Oracle Certified Java SE 11 Developer Certification Exam with code 1Z0-819 in 2021.

18. Can AI Call Its Own Bluffs?

I used TRL library to fine-tune (using both SFT and RLHF) the Llama 2 7b on Google Colab using LoRAs to improve the truthfulness and to detect hallucinations

19. Top 5 Books to Crack Java 8 Certifications 1Z0–808 (OCA) and 1Z0–809 (OCP)

In order to become a Java 8 Certified developer, you need to pass two exams, the OCAJP 8 exam with code 1Z0–808 and the OCPJP8 exam with code 1Z0–809. You will not be a Java SE 8 certified programmer if you just pass the OCAJP8 exam.

20. Deno vs Oracle: Who Really Owns JavaScript?

Deno battles Oracle over JavaScript’s trademark. A fight for open-source freedom with massive stakes for the web's future.

21. dbForge Studio vs. PL/SQL developer: Which Oracle IDE to choose?

Both dbForge Studio and PL/SQL Developer are integrated development environments (IDEs) designed to help with Oracle database developmenttasks and PL/SQL coding productivity. However, just as any two tools,the ones we’re discussing are not exactly the same. Sometimes, it’s very important to know which solution to choose given your specific needs and preferences. In this article, we’ll look at the differences of dbForge Studio and PL/SQL Developer and analyze their strengths and weaknesses in detail.

22. Comparing LLMs' Coding Abilities Across Programming Languages

Benchmark of 5 LLMs solving LeetCode problems in Python, Java, Rust, Elixir, Oracle SQL and MySQL. Results show language popularity correlates with success.

23. How I Prepared for OCP Java SE 11, 2021

I would like to share with you my experience in obtaining the coveted title of Oracle Certified Professional Java SE 11!

24. Node.js vs Java: Why, How, and When to Choose One Over the Other

Recently, my colleagues and I discussed the popularity of a couple of technologies — in particular, Java and node.js. After a brief Internet surfing session, it turned out that these technologies are used by many information giants to develop and maintain their platforms. Below, I will mention only a few of them.

25. 2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many others to see which database management systems are most favored this year.

26. Vagrant with Oracle Database: For When You Need More Than a Container Image!

I’ve written about my love for Vagrant a few times already here, today I will show the steps to getting an Oracle Database with Vagrant.

27. How to Pass the 1Z0-819 Oracle Exam

Recently, I successfully passed the 1Z0-819 Oracle exam. In this article, I will share my prep strategy.

28. Build a Free Personal Heroku with Oracle Cloud and Dokku

Installing Dokku on an Oracle Cloud VM as a free Heroku alternative.

29. How to model an efficient database for your application

What is Database Modeling?

30. The Oracle of Truth: Where Do Blockchain Betting Projects get Their Event's Results?

There are hundreds of blockchain projects proposing to “disrupt” real-world industries, from insurance to sports betting. It seems like a great way to remove intermediaries and fight fraud. Unfortunately, crypto enthusiasts often forget one thing: as soon as external data is involved, blockchain is in trouble.

31. Fixing Oracle DGMGRL Error During Switchover to a Standby Database

Fixing DGMGRL error during switchover.

32. Here's How I Passed The Oracle Certified Professional Examination

In November 2020, I passed the Oracle Certified Professional Java 11 1Z0-819 exam. For me, it was a long journey of 4 months. Sitting with full concentration..

33. Rationalizing Chainlink's Price Rise: A Game of Partnerships

Disclaimer: I don’t stand to gain any benefit from my review of ChainLink. This article is not intended as investment advice. It is just my opinion. As always, DYOR before investing.

34. 3 Steps to Creating Purchase Orders via API in Oracle R12

Creating purchase orders programmatically in Oracle Applications R12 can be done in a reliable and supported way using the Purchasing Documents Open Interface (PDOI). Many developers mistakenly assume that private packages like PO_PDOI_PVT should be called directly, but Oracle does not recommend this approach because it is an internal package that may change across patches […]

The post How to Create a Purchase Order Using API in Oracle Apps R12 [https://vinish.dev/create-purchase-order-using-api-in-oracle-apps-r12] appeared first on Vinish.Dev [https://vinish.dev].

35. Java Concurrency: Understanding the ‘volatile’ Keyword

In this article I would like to talk about some particularities and misconceptions about volatile and the semantics of volatile as defined from Java 5 onwards

36. Develop XR With Oracle, Ep 4: Health, Digital Twins, Observability, and Metaverse

In this fourth article of the series, we focus on XR applications of health, digital twins, IoT, observability, and its related use in the metaverse.

37. Human-Powered Truth Machines and Why They Are Inevitable Oracle Technology

How UMA’s Optimistic Oracle connects any type of real-world, subjective data to smart contracts, and the various use cases it is powering.

38. A Leaker Is Trying to Sell Data From the Supposed Oracle Breach But Nobody's Buying

Oracle has been denying the breach and even since then the hacker’s attempts to sell the stolen information are running into unexpected resistance.

39. Oracle's Larry Ellison and Elon Musk landed on his $2 billion Twitter investment over text

Twitter v. Elon Musk Court Filing, July 12, 2022 is part of HackerNoon’s Legal PDF Series. This is assorted chats between Oracle's Larry Ellison and Musk.

40. The Best Replacement Options for Oracle Commerce Cloud

With Oracle Commerce Cloud being sunset, where should customers look next?

41. The Oracle Database Docker Image Can Supercharge Your DevOps Learning

This is a tutorial on how to install, use, and patch the Oracle Database Docker Image. Docker is a PaaS that delivers software in packages called containers.

42. Playing With Oracle ASM and Multipath Disks - Configuring TrueNAS

I gathered multiple articles on creating a testing environment to implement multipath disks on Oracle ASM and condensed all that information in a single article

43. Automate Customer Creation in Oracle Apps R12 with This Simple API Trick

Customers are the core of the Order-to-Cash (O2C) cycle in Oracle Applications R12. Managing customer data efficiently is critical for processing sales orders, invoices, payments, and overall financial reporting. While customer records can be created manually through the Oracle Receivables (AR) forms, many organizations prefer using APIs for automation, bulk uploads, and integration with external […]

The post How to Create Customer Using API in Oracle Apps R12 [https://vinish.dev/create-customer-using-api-in-oracle-apps-r12] appeared first on Vinish.Dev [https://vinish.dev].

44. SQL Window Functions: A Quick Review With Examples

In this article, we’ll explore some commonly used SQL window functions (ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD(), and LAG()) with examples.

45. Check Out These 8 Free SQL Courses to Learn About Oracle, MySQL, and SQL Server

SQL is very important and many programmers realize this, however, I have found that many more programmers just don't spend much time improving their SQL skills.

46. Why We Should Have Different Databases

Today there are hundreds of SQL and NoSQL databases. Some of them are popular, some are ignored. Some are user-friendly and well documented and some are hard to use. Some are open sourced and some are proprietary. And, perhaps, the most important - some are scalable, optimized, highly available and some are difficult to scale or maintain.

47. Develop XR with Oracle, Ep 5 Healthcare, Vision AI, Training/Collaboration, and Messaging

Explore XR healthcare applications, digital twins, telepresence, and more. Learn how emerging technologies are transforming patient care and medical processes.

48. A Guide to Understanding Blockchain Oracles

Oracles are third-party services that provide blockchain platforms with information about external real-world events as well as external digital events.

49. Comparing Apache Kafka with Oracle Transactional Event Queues (TEQ) as Microservices Event Mesh

This blog contrasts and compares transactional and message delivery behavior of Kafka with the converged Oracle DB and Oracle Transactional Event Queues/AQ

50. The Oracle Solution: Why Decentralizing Everything Is Less Difficult Than it Sounds

In this post, I'll explain why decentralising everything is actually "not that difficult" and what decentralised oracles are.

51. Calling Hugging Face AI From an Oracle Database Using JavaScript

In this blog, I will show you how to quickly create an entirely free app using a JavaScript program that runs within the free Oracle database and calls Hugging

52. Fixing Oracle RAC Node Problems With Addnode: GRID Binaries

Previously, I explained how to fix a node where only the DB binaries were corrupted. Now, let's try to fix a node with only the GRID binaries corrupted.

53. Hierarchical Queries: Comparative Analysis in Oracle and PostgreSQL

A guide about hierarchical querying in Oracle & PostgreSQL, comparing syntax, efficiency, & suitability for diverse data structures.

54. Euler Introduces New Design to Evaluate On-Chain Median Pricing Oracles

Euler introduces a whole new on-chain price oracle design and improves improve upon the Uniswap V3 TWAP (time-weighted average price) oracle design.

55. How to Connect to Oracle, MySql and PostgreSQL Databases Using Python

To connect to a database and query data, you need to begin by installing Pandas and Sqlalchemy.

56. Enterprise Resource Planning & Critical Infrastructure

The issues IT and Cybersecurity teams face in maintaining and protecting ERP systems, including a lack of transparency with business units.

57. SQL Data Modification Commands With Examples: A Quick and Simple Guide

In this article, we’ll explore these commands with practical examples.

58. How Blockchain Could Immunize the Internet Against Distrust

Technology may be powerful, but it’s also fragile. In recent years, a series of events--from Facebook’s Cambridge Analytica scandal to Equifax’s massive data breach--have eroded the public’s trust not only in large companies, but in the Internet itself. The proliferation of fake news has us doubting every article we read. Deepfake photos and videos leave us wondering if we can trust our own eyes, or if what we see is just AI-generated.