How to call a stored function in oracle?
Can objects of the same Schema reside in different tablespaces.?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
How to rename an index?
what is null value?
How to write a query with a left outer join in oracle?
How you open and close a cursor variable.Why it is required?
How much memory your 10g xe server is using?
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
What is a user role in oracle?
Difference between varchar and varchar2 data types?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account