How to insert a new row into a table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
6. Display the client name and order date for all orders using the traditional method.
How many categories of data types?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
What is the usage of merge statement?
DBMS vs. RDBMS
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the uses of Database Trigger ?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
can a table has a column that has only view data and in other columns we can change data?
How to compare dates in oracle sql?
What are the set operators union, union all, minus & intersect meant to do?
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