Skip to content
Advertisement

Tag: oracle-sqldeveloper

Show column according to parameter

I’m trying to write a SQL script that shows a column based on a user parameter. I can’t find an acceptable answer anywhere.  This is a simplified version of what I want to do (in OracleDB): The pseudo code of what I want could be This is the expected result: Answer You can just put the logic into the where

How can i grant an execute statment

I want to grant TRIGGERS, FUNCTIONS and PROCEDURES to a role. I have the code to do it with procedure but with triggers and functions it not work. Answer User owns tables, functions and procedures. That user created a role and wanted to grant execute on various objects to the role. for triggers, it doesn’t make sense – they fire

Advertisement