Is left join faster than join?
No Answer is Posted For this Question
Be the First to Post Answer
what is a sub query?how will you calculate working days in a month using sub query?
How to select unique records from a table?
what is oracle database ? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
Why is normalization important?
What Is a Trigger? How Do You Use It?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What are the properties of a transaction?
Mention what are different methods to trace the pl/sql code?
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)