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 9326How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
1972A 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 45621. 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 6973SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10246I 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 6555
In how many ways you can invoke ssrs reports?
Explain the categories of stored procedure?
What is the xml datatype?
What is a php database?
Write an sql query to select all records from the table?
What is the maximum limit on the number of columns in a table?
What does the not null constraint do?
Does sybase support row level locking?
What is bulk copy or bcp in oracle?
What is difference between stored procedures and application procedures?
What are constraints in microsoft sql server?
What is cursor in mysql?
What is the use of %rowtype?
Are truncate and delete commands same? If so why?
How to retrieve data from an explicit cursor?