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?
2 5201how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
11 11972i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
8 9154can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
1 4120select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
2 6917In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
4 6853suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
5 8334
How to return multiple rows from the stored procedure?
What are primary key and foreign key and how they work?
Are pl sql variables case sensitive?
What is a pragma statement?
Why stored procedure is better than query?
Which certification is best for sql?
Why is there a need for sqlcode and sqlerrm variables?
What does subquery mean in sql?
how to fetch common records from two tables? : Sql dba
What are expressions?
What is the command used to fetch first 5 characters of the string?
Why functions are used in sql?
What is the difference between a primary key and a unique key?
How can we solve sql error: ora-00904: invalid identifier?
what is msql? : Sql dba