explain the advantages and disadvantages of stored procedure? : Sql dba
- 0 Answers
- 529 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
Why is sql*loader direct path so fast?
How do I run a script in sql developer?
Why truncate is faster than delete?
What is right join sql?
how to check server status with 'mysqladmin'? : Sql dba
What are Anti joins
What is a schema? How is it useful in sql servers?
check whether all the emp numbers are indeed unique.
Is sql a backend?
What are the types of variables use in pl sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
