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) how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 9310How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
1964A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
TCS,
1 45551. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
1 6964SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10229I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
TCS,
1 6544
Which database is good for large data?
How do I spool to a csv formatted file using sqlplus?
What is truncate oracle?
How to write a query with a right outer join in oracle?
What are data regions?
Mention a few common trace flags used with sql server?
What is the command line end user interface - mysql?
Can you achieve primary key - foreign key relationships in mongodb?
What do you mean by extension and intension?
How do you create a db file?
How do I find mysql location?
What are the limitations of ms access?
What is updatable resultset?
Write a trigger example in oracle?
Brief theory of Network, Hierarchical schemas and their properties