Interested to Buy Any Domain ? << Click Here >> for more details...
-
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)
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
2697in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
2084What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 8370What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
15 21445I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
3972How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.
2388in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
1 3188Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
2310
Name three of the features managed by the surface area configuration tool? : sql server security
What are group functions in query statements in ms sql server?
Why do not you use gnu autoconf or scons for building?
Explain exception handling in pl/sql?
Why do we need cursor in pl sql?
What is SDL (Storage Definition Language)?
How do I uninstall oracle client from windows?
What is the purpose of save points in oracle database?
How to create a new table by selecting rows from another table in mysql?
What are advantages of dateset in datastage?
List some of the uses of ms access.
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Define normalisation?
What happens if recursive calls get out of control?
Explain the types of exception?
