Interested to Buy Any Domain ? << Click Here >> for more details...
-
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 to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
2760in 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.
2136What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 8481What 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 21864I'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.
4044How 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.
2441in 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 3297Please 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.
2363
Explain what are partitioned views and distributed partitioned views?
Explain the disadvantages/limitation of the cursor?
What is the difference between microsoft excel and microsoft access?
What are transactions in sql?
What are the tool windows in sql server management studio? : sql server management studio
define primary key index, bitmap index, hash index,virtual indwx
Can we insert data into a view?
What is max connection in mysql?
What are the non-standard sql commands supported by 'mysql'?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the maximum number of records in mysql table?
What does pl sql developer do?
What are page splits?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
