Posts

Showing posts with the label ORA-01722

Featured Post

Python Set Operations Explained: From Theory to Real-Time Applications

Image
A  set  in Python is an unordered collection of unique elements. It is useful when storing distinct values and performing operations like union, intersection, or difference. Real-Time Example: Removing Duplicate Customer Emails in a Marketing Campaign Imagine you are working on an email marketing campaign for your company. You have a list of customer emails, but some are duplicated. Using a set , you can remove duplicates efficiently before sending emails. Code Example: # List of customer emails (some duplicates) customer_emails = [ "alice@example.com" , "bob@example.com" , "charlie@example.com" , "alice@example.com" , "david@example.com" , "bob@example.com" ] # Convert list to a set to remove duplicates unique_emails = set (customer_emails) # Convert back to a list (if needed) unique_email_list = list (unique_emails) # Print the unique emails print ( "Unique customer emails:" , unique_email_list) Ou...

How to Resolve ORA-01722 Invalid Number Error in Oracle SQL Developer

Image
When working with Oracle SQL Developer, you may come across an error message that reads "ORA-01722: invalid number". This error can be frustrating and difficult to understand, especially if you're new to SQL. In this post, I will explain the cause of this error and provide a solution to resolve it. Cause of the Error - ORA-01722 Let's consider an example where we have two tables named "my_hr" and "my_dept". The "my_hr" table contains three columns - "name", "pay_id", and "user_id", while the "my_dept" table contains two columns - "name" and "user_id". CREATE TABLE my_hr ( name CHAR(20), pay_id NUMBER, user_id CHAR(6) ); CREATE TABLE my_dept ( name CHAR(20), user_id CHAR(6) ); Now, let's insert some sample data into these tables: INSERT INTO my_hr VALUES ('Srini', 567, '123456'); INSERT INTO my_dept VALUES ('Srini', '123456'); If we try to execu...