Home » SQL & PL/SQL » SQL & PL/SQL » Recreating the sequence in the trigger Oracle 10g (Oracle 10g)
Recreating the sequence in the trigger Oracle 10g [message #411347] Fri, 03 July 2009 03:01 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
How to recreate a sequence XXX inside the trigger ,can anyone help on this

Thanks in advance
Re: Recreating the sequence in the trigger Oracle 10g [message #411348 is a reply to message #411347] Fri, 03 July 2009 03:03 Go to previous messageGo to next message
Littlefoot
Messages: 21014
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Dynamic SQL (if you really want to do that).
Re: Recreating the sequence in the trigger Oracle 10g [message #411356 is a reply to message #411347] Fri, 03 July 2009 03:54 Go to previous message
Michel Cadot
Messages: 64435
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why doing such a silly thing?

Regards
Michel
Previous Topic: how to create partition index on non-partitiion table
Next Topic: if condition
Goto Forum:
  


Current Time: Tue Feb 21 08:29:28 CST 2017

Total time taken to generate the page: 0.18586 seconds