|
| 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 I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible. I am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database? I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change? Latest Answer : DUAL is a table.That is owned by SYS user .It has a column name as dummy and it containts a row having a vale "X".The dual table is useful when u want to retun a value once only,the value that is not derived in from a table with ... 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 Dear Sir,My question is thatI want to add two columns i.e one from first group and another from seconf group. for ex f15 from g_cost_code f17 from g_area_code I think I have to make a placeholder column and add it to g_area_code group but I am not sure please help.Regards,Ashutosh Trivedi Read Answers (1) | Asked by : Ashutosh Trivedi 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 View Question | Asked by : Vikram Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted 1. can we use DML operations on Dual Table?2. What is difference between View and materialisedView?3. New features in Oracle9i SQL? Read Answers (3) | Asked by : vijaya
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
