Explain can a view based on another view?
What is an oracle cursor variable?
What are the differences between blob and clob in oracle?
What is the disadvantage of User defind function?
Is oracle a language?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What is the dynamic sql in oracle?
what is meant by magic query
7. Repeat query (7) but also display all clients who have never ordered anything.
What is a database table in oracle?
if you ctreate table identity
what are the things that you consider while creating indexes on partitioning tables?