Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get list of synonyms in oracle

-- Depending on connected user grants:
SELECT * FROM USER_SYNONYMS WHERE SYNONYM_NAME = 'syn_name';  -- User synonyms
SELECT * FROM ALL_SYNONYMS WHERE TABLE_NAME = 'table_name';	  -- Available to user
SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'schema_name'; -- All schemas
Comment

PREVIOUS NEXT
Code Example
Sql :: linux command line import mysql database 
Sql :: how to check when a stored procedure was last modified in sql server 
Sql :: mysql random limit 1 
Sql :: drop a row in mysql 
Sql :: postgresql search all tables for column name 
Sql :: [2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: ubuntu stop mysql from starting on boot 
Sql :: postgres restart id 
Sql :: find last instance of character in string mysql 
Sql :: get date from now() mysql 
Sql :: Create a keyspace cassandra 
Sql :: oracle sleep 1 second 
Sql :: find column name in database 
Sql :: oracle cpu per session 
Sql :: sql drop multiple columns if exists 
Sql :: count mysql server db tables 
Sql :: oracle list invalid password ORA-01017 
Sql :: t-sql find object by name 
Sql :: tsql try catch 
Sql :: oracle current timestamp 
Sql :: error code 1292 mysql workbench 
Sql :: get the mysql table columns data type mysql 
Sql :: sql query with replace function 
Sql :: update substring in mysql 
Sql :: rows to comma separated values in mssql 
Sql :: async await mysql nodejs 
Sql :: oracle user quota unlimited 
Sql :: oracle current date plus 1 month 
Sql :: mysql update table from select on another table 
Sql :: mysql sum cast decimal without round 
ADD CONTENT
Topic
Content
Source link
Name
8+6 =