How to specify default values in insert statement using oracle?
No Answer is Posted For this Question
Be the First to Post Answer
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How many data types are supported?
Define 'view' advantage ?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
what is query and types of query
What are the various oracle database objects?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is tns service name?
How to rename an index in oracle?
Explain an exception and its types?