List out the difference between commit, rollback, and savepoint?
No Answer is Posted For this Question
Be the First to Post Answer
Display Odd/ Even number of records?
How to use windows user to connect to the server?
What is the implicit cursor in oracle?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
What privilege is needed for a user to create views in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What privilege is needed for a user to insert rows to tables in another schema?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What is difference between Rename and Alias?
What is define in oracle?
What is the relationship among database, tablespace and data file?