Browsing tag: SQL

Tips and Tricks – 1

1. Create unique case-insensitive constraint on a column. Solution: Add function level unique index, example –

2. Cannot create service/sid using ORADIM (DIM-00019: create service error O/S-Error: (OS 5) Access is denied.) Solution: Make sure your oracle service is running. then create instance. To create instance- Open CMD (command prompt) with admin privilege. the type the

Follow Me

Oracle Certification