Explain the difference between drop and truncate commands in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the partition table?
using subquery how can i calculate working days in a month?
What are the new features in Oracle 10g. Compared to Oracle 9i?
What is materialized view. What are different methods of refresh?
What is a parameter query?
what is ref cursor in pl/sql?
Is primary key is clustered index?
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
What is the use of %rowtype?
what is a tablespace? : Sql dba
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
How to execute OS(operating system) command from pl/sql?
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)