Home » SQL & PL/SQL » SQL & PL/SQL » use of sequence (Oracle 9i)
use of sequence [message #325345] Thu, 05 June 2008 21:05 Go to next message
rajboopin
Messages: 7
Registered: December 2007
Location: INDIA
Junior Member
hi,

Since the use of creating sequence is to reduce the table name.

The sequence created by developer is not accessed directly

in the front end instead of that wy not to create a table name

with short name. Please suggest the uses of it.

Re: use of sequence [message #325346 is a reply to message #325345] Thu, 05 June 2008 21:09 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above.

Forgive me, but I don't understand your problem or what you are asking.

I request that you use CUT & PASTE so we can see exactly what you are seeing.
Re: use of sequence [message #325361 is a reply to message #325345] Fri, 06 June 2008 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Since the use of creating sequence is to reduce the table name.

I never see this usage of sequence.

Regards
Michel
Re: use of sequence [message #325406 is a reply to message #325361] Fri, 06 June 2008 02:34 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
rajboopin
the whole message text

As there's no punctuation, it isn't easy to understand what you are talking about. However, as far as I managed to "translate" it, I'd say that you are terribly mistaken. Could you point to the source which lead you to such a statement, please?
Re: use of sequence [message #325508 is a reply to message #325345] Fri, 06 June 2008 07:59 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
rajboopin wrote on Thu, 05 June 2008 22:05
hi,

Since the use of creating sequence is to reduce the table name.

The sequence created by developer is not accessed directly

in the front end instead of that wy not to create a table name

with short name. Please suggest the uses of it.




English please.
Previous Topic: ORA-22288: file or LOB operation FILEOPEN failed
Next Topic: Materialized view + explain plan
Goto Forum:
  


Current Time: Sun Dec 04 12:35:50 CST 2016

Total time taken to generate the page: 0.05372 seconds