摘要: SequencesA sequence:Can automatically generate unique numbersIs a shareable objectCan be used to create a primary key valueReplace application codeSpeeds up the efficiency of accessing sequence values when cached in memory.CREATE SEQUENCE Statement SyntaxDefine a sequence to generate sequential numb 阅读全文
posted @ 2013-04-10 13:58 ArcerZhang 阅读(201) 评论(0) 推荐(0) 编辑
摘要: ObjectivesAfter completing this lesson,you should be able to do the following:Create simple and complex views.Retrieve data from views.Create,maintain,and use sequences.Create and maintain indexes.Create private and public synonyms.Lesson AgendaOverview of views-Creating,modifying,and retrieving dat 阅读全文
posted @ 2013-04-10 11:48 ArcerZhang 阅读(151) 评论(0) 推荐(0) 编辑