Does ORACLE have any construct like Sql Server's schema? -



Does ORACLE have any construct like Sql Server's schema? -

i sql server coder, have client wants move scheme sql oracle due new licensing model of sql server.

i know historically, oracle has no logical grouping of objects within db/schema, along lines of sql server schema. it's been while since i've done real oracle work though, i'm wondering if somewhere along line, may have added such construct?

the version of oracle porting sql server database oracle 11g (11.2).

traditionally, i've seen oracle developers using prefix on table/view/object names. illustration sql server object users.options might become usr_options in oracle. works sure, feels kludgey me, it's not much actual hierarchy, sort of "forcing" 1 in using contorted names.

oracle has schema back upwards in oracle 11gr2. oracle schemas tied user. you'll have (somewhat confusingly) create user each schema you're creating. isn't big deal, people find distasteful.

oracle 12c enterprise edition has feature called multitenant allows multiple databases on same oracle server in much same way sql server allows out of box.

sql-server oracle oracle11g language-features

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more