What is analyze command used for?
No Answer is Posted For this Question
Be the First to Post Answer
How to loop through a cursor variable?
What is a Shared SQL pool ?
How to invoke the data pump export utility?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Which is better Oracle or MS SQL? Why?
how to find count rows in table without count function?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to specify default values in insert statement using oracle?
Explain mutating triggers.
Can we convert a date to char in oracle and if so, what would be the syntax?
After using set unused can we enable the column again to use? Please give me some answers....
What is index in Oracle?