How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
No Answer is Posted For this Question
Be the First to Post Answer
What is nvarchar max in sql?
How exception handling is done in advance pl/sql?
What is a unique key?
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?
Where is sql database stored?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
What is the Subquery?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
What are the datatypes available in pl/sql ?
25.67,-1 Trunc = 20 Round= 30 HOW????
What is a full join sql?
What is execution plan in sql?