How many parts of a pl sql block are optional?
No Answer is Posted For this Question
Be the First to Post Answer
What is full join?
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
Why is sql better than hql?
What is the difference between the conventional and direct path loader? : aql loader
Why query optimization is needed?
What are the different types of triggers?
can we update a view which is created from two tables
Is natural join same as inner join?
Which type of cursor is used to execute the dml statement?
What is an escape character in sql?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
What is mutating table error?
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)