Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 11 months ago. Improve this question In the Name_code column, we have these types of I want O/P the value like this SUBSTR(Name…
Tag: plsqldeveloper
Find Stored Procedure By Table Name (Oracle)
Need help. Every morning at 4 o’clock a table is created in the database, I need to understand what sources are used to create it, so I tried to find a stored procedure that creates this table using all_source or dba_source (select * from all_source where upper(text) like ‘%TABLE_NAME%’, but…
ORA-00907: missing right parenthesis. I am passing a Variable ‘&Coordinator_Id&’
ORA-00907: missing right parenthesis I am trying to run the code and I am keeping getting the right parenthesis error I checked the entire code. Could somebody see why I am failing? Answer As mentioned in comments a case expression evaluates to a value, which you can then use or compare to something else. In …
query inside the exception and begin block in exception
Hello I want to ask what is the best practise to do. First example try to retrieve my data through exceptions I use this code in my main application and is working fine but I dont know if its good practise to code inside the exceptions blocks SECOND EXAMPLE TRY TO RETRIEVE DATA WITH CASES AND SELECT WITH COUN…
Error(8,1): PLS-00103: Encountered the symbol “SET”
I’m trying to create a function using oracle, it should be working fine but i keep getting the following error: Error(8,1): PLS-00103: Encountered the symbol “SET” here is my Function: Answer The problem is where do you put this command: SET SERVEROUT ON; cause its inside the function declar…
Handle a very large string in pl/sql script
I am trying to run below code which reads the index definition for table A so that it can be created again after I delete/create that in this script. This script runs fine when the returned value(ddl) …