Home » SQL & PL/SQL » SQL & PL/SQL » write a calendar
write a calendar [message #348701] Wed, 17 September 2008 12:41 Go to next message
new_sri
Messages: 2
Registered: September 2008
Junior Member
Hello sir,

pls help me in clearing my doubts:
all_objects....what table it is?


i just completed SQL and my sir gave me mini project to write a calender with SQL
Re: Calendar table - An AskTom solution. [message #348702 is a reply to message #348701] Wed, 17 September 2008 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget this topic and search for younger one (there are many about calendars). In 3 years Oracle improved its products.

About your question, try: desc all_objects

Regards
Michel
Re: write a calendar [message #348727 is a reply to message #348701] Wed, 17 September 2008 15:59 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You need to create a calendar. It contains "a lot" of records, so - what table (view) already contains many records? ALL_OBJECTS! Just as an example: at the moment, my "home" database contains > 40.000 records in all_objects.

This principle can still be used, but - as Michel has already said - Oracle has developed an "improved" solution to the row generator technique (use of the LEVEL pseudocolumn).

Now that you know a short background, do the search by yourself.
Re: write a calendar [message #348760 is a reply to message #348727] Wed, 17 September 2008 22:04 Go to previous message
new_sri
Messages: 2
Registered: September 2008
Junior Member
thank u for the help
Previous Topic: How to alter index
Next Topic: loading data fro excell to a table
Goto Forum:
  


Current Time: Tue Dec 06 02:54:07 CST 2016

Total time taken to generate the page: 0.09522 seconds