Does SQL*Plus contains pl/sql Engine?
Answer / sushma
No.
SQL*Plus is an interactive program that allows you to type
in and execute SQL statements. It also enables you to type
in PL/SQL code and send it to the server to be executed.
SQL*Plus is one of the most common front ends used to
develop and create stored PL/SQL procedures and functions.
The important thing is that SQL*Plus does not execute your
SQL queries. SQL*Plus also does not execute your PL/SQL
code. SQL*Plus simply serves as your window into the Oracle
database, which is where the real action takes place.
| Is This Answer Correct ? | 15 Yes | 1 No |
What is a primary key, and how is it different from a unique key?
Can we use commit inside a trigger?
Do we need to create index on primary key?
what is a stored procedure? : Sql dba
What is normalization? How many normalization forms are there?
Describe types of sql statements?
What is microsoft t sql?
what is self join and what is the requirement of self join? : Sql dba
How to call shell script from pl sql procedure?
What is a behavioral trigger?
What is the command used to fetch the first 5 characters of a string?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)