LEFT function in Oracle

There is no documented LEFT() function in Oracle. Find the full set here.

Probably what you have is a user-defined function. You can check that easily enough by querying the data dictionary:

select * from all_objects
where object_name = 'LEFT'

But there is the question of why the stored procedure works and the query doesn’t. One possible solution is that the stored procedure is owned by another schema, which also owns the LEFT() function. They have granted rights on the procedure but not its dependencies. This works because stored procedures run with DEFINER privileges by default, so you run the stored procedure as if you were its owner.

If this is so then the data dictionary query I listed above won’t help you: it will only return rows for objects you have rights on. In which case you will need to run the query as the stored procedure’s owner or connect as a user with the rights to query DBA_OBJECTS instead.

Related Posts:

  1. ORA-00904: invalid identifier
  2. how to fix oracle ORA-01722 invalid number error
  3. ORA-00979 not a group by expression
  4. ORA-00907: missing right parenthesis
  5. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  6. ORA-01843 not a valid month- Comparing Dates
  7. ORA-00918: column ambiguously defined in SELECT *
  8. Oracle error : ORA-00905: Missing keyword
  9. How do I limit the number of rows returned by an Oracle query after ordering?
  10. Oracle SELECT TOP 10 records
  11. Can a foreign key be NULL and/or duplicate?
  12. How to Select Top 100 rows in Oracle?
  13. ORA-12560: TNS:protocol adaptor error
  14. ORA-00972 identifier is too long alias column name
  15. Oracle Apex column link from LOV values
  16. PLS-00103: Encountered the symbol when expecting one of the following:
  17. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  18. ORA-00918: column ambiguously defined in SELECT *
  19. ORA-00918: column ambiguously defined in SELECT *
  20. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  21. ORA-01861: literal does not match format string
  22. What is it exactly a BLOB in a DBMS context
  23. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  24. How do you create a temporary table in an Oracle database?
  25. Oracle “Partition By” Keyword
  26. How to insert date values into table
  27. Oracle SQL: Update a table with data from another table
  28. SQL selecting rows by most recent date with two unique columns
  29. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  30. Comparing Dates in Oracle SQL
  31. Convert timestamp to date in Oracle SQL
  32. How do I reset a sequence in Oracle?
  33. Update statement with inner join on Oracle
  34. MySQL equivalent of DECODE function in Oracle
  35. Oracle: If Table Exists
  36. DATEDIFF function in Oracle
  37. How to create id with AUTO_INCREMENT on Oracle?
  38. What is the difference between Views and Materialized Views in Oracle?
  39. How do I view the Explain Plan in Oracle Sql developer?
  40. ORA-01779: cannot modify a column which maps to a non key-preserved table
  41. ORA-01735: invalid ALTER TABLE option – Toad
  42. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  43. What is a stored procedure?
  44. Unknown column in ‘field list’ error on MySQL Update query
  45. SQL Inner-join with 3 tables?
  46. Conversion failed when converting date and/or time from character string while inserting datetime
  47. QL Error: ORA-00933: SQL command not properly ended
  48. error, string or binary data would be truncated when trying to insert
  49. Rename column SQL Server 2008
  50. Why do we need “Relationships” between tables at all?
  51. Using group by on multiple columns
  52. How to declare a variable in MySQL?
  53. How do I escape a single quote in SQL Server?
  54. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  55. must appear in the GROUP BY clause or be used in an aggregate function
  56. How can I return pivot table output in MySQL?
  57. MySQL syntax for Join Update
  58. SQLite – UPSERT *not* INSERT or REPLACE
  59. how to drop partition without dropping data in MySQL?
  60. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  61. Insert text with single quotes in PostgreSQL
  62. SQL Server IF NOT EXISTS Usage?
  63. Arithmetic overflow error converting numeric to data type numeric
  64. I want to use CASE statement to update some records in sql server 2005
  65. SELECT DISTINCT on one column
  66. how to remove time from datetime
  67. TSQL PIVOT MULTIPLE COLUMNS
  68. Query to convert from datetime to date mysql
  69. How to query MongoDB with “like”
  70. Equivalent of Oracle’s RowID in SQL Server
  71. Subtract one day from datetime
  72. what is the difference between triggers, assertions and checks (in database)
  73. Replacing NULL with 0 in a SQL server query
  74. How to delete from multiple tables in MySQL?
  75. How to copy a row and insert in same table with a autoincrement field in MySQL?
  76. Error converting data type varchar
  77. I want to use CASE statement to update some records in sql server 2005
  78. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  79. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  80. ROW_NUMBER() in MySQ
  81. MySQL OPTIMIZE all tables?
  82. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  83. Is there a coalesce-like function in Excel?
  84. How do I count unique items in field in Access query?
  85. MySQL LIKE IN()?
  86. Filter data based on date in sql
  87. What is a postgres superuser
  88. SQL query to extract only the “current” wp_posts?
  89. How to retrieve sticky post in raw sql?
  90. How to remove in the wordpress database all posts revisions except the last three?
  91. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  92. $wpdb get_var issue
  93. Auto-update tables from database
  94. Inserting rows into a custom table, when plugin is activated
  95. Posts modified in the last 48 hours
  96. post id not displaying
  97. Insert multiple checkbox values
  98. How to get EVENT based on startday, using BETWEEN
  99. Firebase with WordPress instead of SQL?
  100. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date

Leave a Comment