how to run plsql code

By ukmodak | March 31st 2024 10:32:28 AM | viewed 697 times

1 Install database

2 go to oracle home directory and create a file with .sql extension and write pl/sql code on it

3 cmd>sqlplus

4. enter sys as sysdba and enter sys password

3 cmd>alter session set container=apexukpdb;

grant connect to ukaccount;
grant all privileges to ukaccount;

Go to start->cmd

sql>@directory\filename.sql enter (best) // or copy and pase code on it and enter(may be face problem)

bONEandALL
Visitor

Total : 26654

Today :3

Today Visit Country :

  • France
  • United States