Alright it worked for blah:
cursor.execute("DROP SEQUENCE BLAH_SEQUENCE")
Going for the rest now.
On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer wrote:
>
> Ahh, I am ULTRA-Newb to db's:
>
> here is what it returned:
>
> >>> for row in cursor:
> ... print row
> ...
> ('SYS_C0012098', 'INDEX')
> ('SYS_LOB0000092306C00003$$', 'LOB')
> ('AUTH_CAS_SEQUENCE', 'SEQUENCE')
> ('AUTH_EVENT_SEQUENCE', 'SEQUENCE')
> ('AUTH_GROUP_SEQUENCE', 'SEQUENCE')
> ('AUTH_MEMBERSHIP_SEQUENCE', 'SEQUENCE')
> ('AUTH_PERMISSION_SEQUENCE', 'SEQUENCE')
> ('AUTH_USER_SEQUENCE', 'SEQUENCE')
> ('BLAH_SEQUENCE', 'SEQUENCE')
> ('AUTH_USER', 'TABLE')
>
>
> I just googled dropping Objects. Wish me luck. ill report back.
>
>
> On Monday, December 28, 2015 at 9:59:18 AM UTC-8, Dan Feeney wrote:
>>
>> You can view tables owned by the current user with:
>>
>> SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME;
>>
>>
>>
>> You can view all objects owned by the current user with:
>>
>> SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1;
>>
>>
>>
>> HTH,
>> -Dan
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
