I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.
I have created index. It shows Type as *FILE and Attribute as LF.But i am unable to view the data. how do i view index's data?
I have created sequence using CREATE SEQUENCE command. Then i have noticed that one data area is created in the same name. what is the actual purpose of sequence?
I have created table using CREATE TABLE Command. I want to see the source of Table. Is there possiblity to view the TABLE's Source in AS400
We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?


