I was trying to search for ways to list all columns where special characters are entered. If some one can help in doing a lookup in a certa...
We can fetch sequence number using 3 commands: DBA_SEQUENCES all sequences that exist ALL_SEQUENCES all sequences that you have permi...
Use the following script to verify an oracle user lock status. select username, account_status, created, lock_date, expiry_date from dba_u...
Recently came across the error on running crystal report. The report was developed some time in 2009, using an older version of oracle. T...
The following tables provide DB structure details: 1. user_objects - It lists all the objects owned by logged in db user. 2. ALL_OBJECTS ...
Came across a scenario where the Select statement output was only based on a CASE statement and the output was required with an ALIAS_NAME. ...
Use the following query to read the source code. select * from all_source where name = 'XXXX_XXX_XX_X'; All_Source keeps the tex...
Hi folks, I was working on a report that required the output to club 2 columns but separate them with a carriage return. Following query ...
Struggling to read a stored proc in oracle Run the following script and get rid of your quag. select type, text from all_source wher...
Oracle provides a default View to list all available users in database. ALL_USERS [It lists all users visible to currently logged in user...
Run the following query to identify the Primary Key in a table in Oracle DB: SELECT cols . table_name , cols . column_name , cols . posi...
Use the following query to read a SP in SQL PLUS or database developer for oracle. SELECT * FROM ALL_SOURCE WHERE NAME = 'SP_EXTRACT_...
To get list of all Stored Procedure in an Oracle DB, run the following query: Select * from ALL_OBJECTS WHERE OBJECT_TYPE IN ('PACKAGE...
To get list of all views in ORACLE run the following query: SELECT view_name FROM all_views;
In ORACLE we have a view called "cols", it can be used to ascertain which table contain a given column: SELECT table_name, colum...
A) If user has access to all the tables, i.e. DBA grant provided, run the following query: SELECT OWNER, TABLE_NAME FROM dba_tables B)...
On installing ORACLE 11G Client on a windows machine, the provider ORACLE OLE DB is not installed on the machine. If user tries to connect...
To export DDL. 1. Access the database on TOAD. 2. From Menu options Select DATABASE --> EXPORT --> EXPORT DDL ...
Posts
