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 |
How do you write an index?
Can We write bulk collect statement in triggers?
Explain normalization and what are the advantages of it?
If a View on a single base table is manipulated will the changes be reflected on the base table?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is RAC in oracle?
Difference between global and parameter variables?
What is window clause?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What are the types of SQL Statement?
What are pl/sql exceptions? Tell me any three.
what is the difference between sql and t-sql? : Transact sql
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)