ORA 00904 Error:Invalid Identifier

by

Use single quotes.

select fname,lname from reg1 where uname="bbb";

More Related Contents:

  1. ORA-00904: invalid identifier
  2. Using an Alias in a WHERE clause
  3. Using ‘case expression column’ in where clause
  4. How to use BOOLEAN type in SELECT statement
  5. Is it possible to query a comma separated column for a specific value?
  6. How to use Alias in Where clause? [duplicate]
  7. LISTAGG in Oracle to return distinct values
  8. Fetch the row which has the Max value for a column
  9. Oracle SQL: Update a table with data from another table
  10. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  11. Concatenate and group multiple rows in Oracle [duplicate]
  12. Difference between BYTE and CHAR in column datatypes
  13. SQL to generate a list of numbers from 1 to 100
  14. Call a stored procedure with another in Oracle
  15. How to show all privileges from a user in oracle?
  16. SQL – How to select a row having a column with max value [duplicate]
  17. Oracle: loading a large xml file?
  18. IF EXISTS condition not working with PLSQL
  19. Using pivot on multiple columns of an Oracle row
  20. Check if current date is between two dates Oracle SQL
  21. Benefits Of Using SQL Ordinal Position Notation?
  22. Unordered results in SQL
  23. Oracle Dynamic Pivoting
  24. create custom function for date difference excluding weekends and holidays in oracle sql
  25. What is it exactly a BLOB in a DBMS context
  26. Custom Order in Oracle SQL
  27. Compare Strings ignoring accents in SQL (ORACLE)
  28. How can I solve ORA-00911: invalid character error?
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment