Recent content by 13579

I have a Search field . When user enters a value in the Search field, I want to display the first 10 rows which match the query, then the next 10..and so on. but problem is i use cursor inside the select statement.because i use nested table. this is the query select t.empid,t.empname,cursor(...

I have a Search field . When user enters a value in the Search field, I want to display the first 10 rows which match the query, then the next 10..and so on. I will give How do I go about it?

i want to out the result as a ref cursor.can i include cursor in that ref cursor like the following procedure get_data(idea_cur out GenericCursorType) Is Begin open idea_cur for select t.deptid,t.deptname,cursor(select a.id,a.namefrom TABLE(t.emp) a) from dept t; End ;

u can find the role of particular user using following two table sys.dba_users , sys.dba_sys_privs

thanks jflack.

Thanks.But one of my friends says,u can generate table without having primary key or surrogate key.also can i stop those unneccessary sequences.

I created Entity Relationship Diagram.I can generate Table relavant to that every entity.(using Database Design Transformer).Normaly the Database Design Transformer tries to find a suitable unique key that can be used as the primary key. If it cannot find one, it creates a surrogate primary...

How to generate table without primary key from Entity Relationship Diagram using Database Design Transformer