My table has duplicate values pls help me How can i delete those values For Ex: my table contains 200 rows in that 100 rows are duplicate values and i can i delete those 100 rows pls give me answerregardsmangaiah
Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks
Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted
Rownum is used to get tha top-N values. What if I want to know the value at specific position?EX: A table emp has two columns e_name and e_salary. How can I list the e_name of the employee who is getting the third highest salary?
I want to use a column as blob datatype incase of long raw datatype.what is the process of data insert into and retrive from this table .
Latest Answer : In order to understand wht is a clustered index in oracle it is imp. to know what is a cluster. A cluster is a method to store data for more than 1 table in the same block.This can be compared to a condition where we have a join condtion of 2 tables(primary ...
Hi All, Getting the following error in Oracle9i on AIX, unique index ORA-01652: unable to extend temp segment by 128 in tablespace USERS; though the USER tablespace is of 10gb.Could anyone provide a solution.Regards,Ashish Thomas
hii i have a emp table .empno stores all the numeric valuesand accidentally i have added some values with combination of alphabets and special charactersnow i need a query which will return all the records
Latest Answer : Hello ,First of all if you can tell me what version you are using that will be great Cause Oracle10 has reqular expresion property.Mean while i would sugest to write a page where you can get all the Emplids,Iterate them and check if they are ...
Latest Answer : Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr) ...
Usually if a large amount of data entry/updation/deletion is to be done, the index is dropped and re-created after the data entry/updation/deletion is finished, Why?
