Helpful Oracle hints I've found and saved
Currently Browsing: Software

Creating Users in SQL Developer

I tend to prefer using SQL commands to create and update things in Oracle. I'm not sure why, maybe it just makes me feel like I actually know what's being done when something happens. You could create a User object in Oracle using an SQL query like the following: CREATE USER "THE_USER_ID"  PROFILE "DEFAULT" IDENTIFIED BY "THE_PASSWORD" DEFAULT TABLESPACE "THE_TABLESPACE" TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED...

Oracle SQL Developer

The first thing you should do when you want to start playing with Oracle databases is download "SQL Developer" from Oracle. The new version (v 2.1 as of this writing) is a little prettier than the previous version, and I haven't even managed to use all the features yet. You can download it from here: http://www.oracle.com/technology/software/products/sql/index.html It's quite a large piece of software, especially...
Powered by WordPress | Designed by Elegant Themes

Pin It on Pinterest