oracleoracle-sqldeveloper
How to view synonym procedure in sql developer?
I have a procedure, function synonym from production environment. When i search with name in sql developer it shows in a list, but when i click to view it just show CREATE synonym statement only not a code. But in TOAD it will show by pressing F4 key i think.
How i able to view that synonym procedure in SQL developer tool?
Solution
Place your cursor on the syn name in your pl/sql block.
Right click, Popup DESC
This will open the underlying PL/SQL program, in this case, a procedure in my schema.
- How to replace null values with a text?
- Microsoft SSIS - Issues switching from attunity driver to new Microsoft Oracle Connector v1.3
- Writing SQL Query With Same Client ID , same Tax_year, same Tax_effective_date But with Different Tax_id & Payroll_ID in ORACLE SQL
- Oracle XE installation aborts with no error explanation
- How to process tabular data from Oracle PL/SQL function in JAVA?
- How do you execute SQL from within a bash script?
- How to connect to Oracle 8i using Java
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- How to sort all numbers before letters with linguistic sorting?
- Oracle Sql Statement for unique timestamp for each row
- ambiguity error when adding pivot to existing SQL oracle statement
- Within PL/SQL script create table based on Oracle Edition
- Connect to sqlplus in a shell script and run SQL scripts
- Oracle SQL hierarchical query data accumulation
- Does Oracle field contain all letters from a string?
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- ORA-00902: invalid datatype with EF Core
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- ORACLE APEX ADMIN LOGIN ISSUE
- Fetch last row for each month, or previous month if not found
- How to update/add large amount of data into Oracle database from ASP.NET Core
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- Why my query to select from Oracle database turn to text (blank query) every time i run it
- Oracle ORA-00902 Invalid datatype error
- Check if Advanced Compression is available
- Strange full table scan statements in Oracle
- Options to enforce a logical constraint in an Oracle database
- How to sort numbers before letters with linguistic sorting?
- Oracle Trigger Creation Error: PLS-00049 BAD BIND VARIABLE 'OLD'