sqloracleoracle10goracle-xe
Oracle shows "no data found" when I try to retrieve data from existing column
I have created DriversTable that stores details like Name, Age, Gender etc as shown in the screenshots below.
When I try to retrieve data in a row based on the Availability column that exists in the DriversTable, it says "no data found".
But when I try to retrieve data based on the Gender column, it shows the result as expected
I don't know why this is happening, is it some kind of exception in database or am I doing something wrong ?
Please help
Solution
This might be caused by columns having "hidden" characters. Often these are spaces at the end of the value.
To test this, use LIKE:
where availability like 'Availability%'
If this occurs, then there are probably spaces (but there could be something else). The most common issue is that a column is declared using CHAR() rather than VARCHAR2().
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- PHP XAMPP Config
- SQL select distinct with condition
- To get the previous record which is less than the given date and time
- Create OBJECT with column values as Key in Snowflake
- How to load multiline csv feature into MySQL
- SQL copying data with new foreign keys
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
- SQLAlchemy - Get query results in same order as IN clause
- SQL Grouping and Nested Concatenation
- Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
- How can I refer to a variable in postgresql dynamic SQL?
- How to pull width & height out of string?
- Add new columns without using Alter
- Get columns of index on DB2
- Athena Query - "NOT IN" slow performance
- SQL one to one relationship vs. single table
- How can I number the instance of a duplicate record?
- How to fix SQL for AWS Athena
- SQL SELECT query not working in mysql
- How can i insert/ select into a table and delete copied records from original table?
- How to convert oracle regex pattern into Databricks compatible version?
- Select min or max based on where duplicate value exists
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- WHERE clause pulling incorrect values
- Sql select all conversation by group
- Create an inline SQL table on the fly (for an excluding left join)
- How to execute raw SQL in Flask-SQLAlchemy app