SQL







No Picture

Change Sys user password in Oracle

To change sys user password in Oracle follow these steps: 1.  Run Rman.exe from the oracle_homebin directory. 2.  On prompt type          Connect Target [and press enter]         SQL “Alter user sys identified by newpsw”; [press enter]3. …



No Picture

Generating Random Data Problem

Generating Random Data Problem You need to generate random numbers to simulate real-world events that do not follow a discernible pattern. Solution Use the Oracle built-in PL/SQL package DBMS_RANDOM. The RANDOM function returns an integer…