how to run plsql code

By ukmodak | March 31st 2024 10:32:28 AM | viewed 325 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 : 20972

Today :26

Today Visit Country :

  • Germany
  • United States
  • Singapore
  • China
  • United Kingdom
  • South Korea
  • Czechia