What is the use of partition by in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Mention what does the hierarchical profiler does?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
Explain the working of foreign key?
Can you have more than one key in a database?
What are the new features in Oracle 10g. Compared to Oracle 9i?
What are the different sql languages?
What is vector point function?
What is the use of triggers?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Explain the types of joins in sql?
what is text? : Sql dba
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)