What is %type in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is write ahead logging in sql server?
What are some predefined exceptions in pl/sql?
What is the criteria while applying index to any column on any table.
What is the difference between an inner and outer join?
Explain the PL/SQL compilation process.
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Name some usages of database trigger?
What is query execution plan in sql?
Why commit is not used in triggers?
Why do we use triggers?
Can we create clustered index without primary key?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
Oracle (3253)
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)