Answer Posted / ravindran
Select upper('tamilnadu') from dual; There is no toupper
function in Oracle
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the different types of fact tables used in data warehousing?
Explain is fact table?
How to get the first 100 rows from the flat file into the target?
Explain the difference between data ware house & data mart?
Why null values are mapped as 0 in fact tables?
Can you state some of the innovations throughout history?
Explain differences between star and snowflake schemas?
Explain how are the dimension tables designed?
What is Operational Data Store?
How can we run the graph? What is the procedure for that?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is vdl (view definition language) explain?
The same tier?
What is the function of surrogate key in data warehousing?