How to delete duplicate values from tableFor Ex: A table contains 200 rows in that 100 rows are duplicate values, how to delete those 100 rows?
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
How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select?
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?
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) ...
Is it good programming practice to avoid the use of SELECT *. Is it better to list coloumn names. Why?
Evaluate this query?Select e.emp_id from emp@wing e; What is "@wing" ? Is it a partition on emp table or a constraint on table emp?
Latest Answer : Select statement works in the same way as other querries. The result set is brought from the Datafile if not already in Buffer cache. As we are aware that Buffer cache works on LRU and MRU algorithm to retain or flush out the data to and from buffer ...
