What does plv msg allows you to do?
No Answer is Posted For this Question
Be the First to Post Answer
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
What is sap sql?
what is the difference between union and union all? : Sql dba
How to start the command-line sql*plus?
Can we use ddl statements in stored procedure?
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
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 are inner and outer joins examples of both?
What is trigger price?
How many types of cursors are available in pl/sql?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
Is it mandatory for the primary key to be given a value when a new record is inserted?
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)