What function should we use to display the value entered or selected by a user in response to a prompt?
Answer / Alok Srivastava
In SQL, there is no built-in function for this. However, some database systems like Oracle and MySQL provide command line interfaces that support prompts. In programming languages, functions like input(), readline() etc are used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what is real time data-warehousing?
Where the cache files stored?
Explain the versions of reportnet?
What is data validation strategies for data mart v?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
How to know the time taken for particular report execution?
Tell me what is full load & incremental or refresh load?
I need to set predefined condition. How I do this?
what is the difference between etl tool and olap tools
How are the dimension tables designed?
How to performance tune reports?
What are the main steps to build the data warehouse?