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 ...
Posts
