The Cloud! You may have heard a few things about Cloud services and Oracle over the past few years. What I’m going to talk about today is our Database Schema Service offering. It’s what it sounds like, pretty much. On a kick-butt Exadata box, you get your own schema in a database that we take […]
Similar Posts by Subject Areas: cart, cloud, Schema, service, sqldev
Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply […]
Similar Posts by Subject Areas: hide, objects, Schema, sqldev, user
I’m at a friend’s house, sans laptop, so today’s post will be short and sweet. Also, no pictures! In your connection tree, on an active (connected) connection, right-click and select the Schema Browser. If you hop around users/schemas frequently in a database, you may enjoy the drop-down control for toggling.
Similar Posts by Subject Areas: Schema, sqldev
Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing […]
Similar Posts by Subject Areas: data modeling, Schema, sqldev