|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 Read Answers (2) | Asked by : vishnu Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted Hi,Subject: Oracle Apps :Order Management PTO,ATO, CTO Currently i am working on PTO they have some PTO type of orders. They call it Custom Config. The Customer may want to order something that requires Picking and Assembling multiple items from Inventory. The example Ram has given below is representative of what they would do now in FACTS.In this example they put Lines 1.1, 2.1, and 3.1 on the Order. However, Line 3.1 is made up by combining lines 1.1 and 2.1They then release the order and it reserves View Question | Asked by : Kalyan 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 ... Read Answers (1) | Asked by : srikanth 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) ... How to retrieve multiple row values in a single column Latest Answer : Dear friend, I didn't get exactly what you want,any please tell me the context so that i can help you out................coming to the question:you want the result of multiple rows in a single column..........well this you can get by using group ... Explain how to retrive index values in Oracle SQL?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
