schema

How can I see other schemas apart from my own when connecting to an Oracle database through server explorer?

I am attempting to add a connection to an Oracle database through Server Explorer. The 'Test' Connection' is successful, however whenever I go to view the list of tables / schemas, I can only see the one associated with my login. I realise this sounds silly, but when I use the same login/password through Toad for Oracle, I am still allo...

Oracle: exporting only schema

Hello I have an Oracle 10g database, and now I need to export, if possible, only the schema. (Only table structures with index etc... without data!) Is this possible with exp/imp or do I need expdp/impdp? Greets ...

Deploy web app on a server but pointing to many database schemas

I have a web service app that has an xml file with Oracle connection properties i.e. DEVFOOBAR schema. I will create a war file of this and deploy to Tomcat on our test server - however we only have this one server but we want the ability to test the webservice against a few different schemas e.g. DEVFOOBAR TESTFOOBAR UATFOOBAR LIVE...

What is the better way to store an arbitrary key:value array in mongodb

I have an array of key values {val1: [{gender:male}, {age:23}, {favorite-color:red}] } The thing about this array is that in no way is it structured and in no way am I ever guaranteed to see the same key value again. For example I could see the following for val2 {val2: [{sex:male}, {hair-color:red}, {height:6'1"}] } My quest...

Python XML Parse (using schema to generate dataset)

I'm looking to parse a xml file using Python and I was wondering if there was any way of automating the task over manually walking through all xml nodes/attributes using xml.dom.minidom library. Essentially what would be sweet is if I could load a xml schema for the xml file I am reading then have that automatically generate some kind o...

Yet another question regarding the html5 dtd/schema

If there is no DTD or schema to validate the H5 document against, how are we supposed to do document validation? And by document validation, I mean "how are we supposed to ensure our html5 documents are both syntactically accurate and structurally sound?" Please help! This is going to become a huge problem for our industry if we have no ...

Can SQLite support this schema?

Hi, imagine I have this table called Department. Each Department can have child Departments. I was thinking of having a column called ParentDepartmentID as foreign key to another department. If this key is null, it means it's a Parent top class department and not child of any other department. I guess you could call this a self referen...

generate annotated doctrine2 entites from db schema

Is it possible to generate Doctrine 2 entities, with the relevant docblock annotations, from an existing database schema? ...