how to run plsql code

By ukmodak | June 6th 2022 12:23:03 PM | viewed 221 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 : 18979

Today :8

Today Visit Country :

  • Germany
  • Singapore
  • United States
  • Russia