Why cursor variables are easier to use than cursors?
No Answer is Posted For this Question
Be the First to Post Answer
What are the differences between date and timestamp in oracle?
What is the difference between hot backup and cold backup in oracle?
What is a database table in oracle?
Can a formula column be obtained through a select statement ?
How to write a query with an inner join in oracle?
how to clone 9i Database on to 10g Database.
What is the data type of dual table?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How to set a transaction to be read only in oracle?
How does oracle handle read consistency?
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!