The insert statement adds a new row or rows in a table in theOracle database. We generally use it after we have created a table in the database. One important point to remember is that while inserting records into a table, we must provide a value for every NOT NULL value. Let us lo...
Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. In this post we'll look at the purpose of an index, how to create and choose choose your index type. Then finish with a discussion of how to decide what to index and
UNDO TABLESPACE: In the previous section, we discussed the definition of UNDO TABLESPACE. At this point, we are going to discuss creating an UNDO TABLESPACE in the Oracle database. For example, we will try to create an UNDO TABLESPACE with a size of 4MB with the AUTOEXTEND as ON as well...
Create a customer data strategy Those who master data understand their customers better, can deliver the experiences they crave, and, in many cases, anticipate what steps they should take in anticipation of their customers' wants. However, data means nothing if you're not able to analyze and ...
create table toys ( toy_name varchar2(10), weight number, colour varchar2(10) ) organization heap;Heaps are good general purpose tables. They are the most common type you'll see in Oracle Database installations.With these, the database is free to store new rows wherever there is sp...
Converting to a String in Oracle SQL As with the NUMBER data type, there are two ways to convert a value to a string data type. The main string data types in Oracle are: CHAR NCHAR VARCHAR2 NVARCHAR2 TEXT TheTO_CHAR functiontakes a value and converts it to a TEXT data type. It wo...
oracle (phys-paris-1)$dgmgrl sys/sysdba_password@sales-svcDGMGRL>create configuration mysales.com as primaryDGMGRL>database is sales connect identifier is sales-svc; If you find errors when you connect to the Oracle Data Guard Broker, check the${ORACLE_HOME}/admin/sales/bdump/alert_prim_sid...
I’ve always appreciated the CREATE OR REPLACE functionality in Oracle for views, packages and triggers, and I’ve often wanted a similar CREATE OR REPLACE TABLE. Many times, I’ll find myself needing to quickly drop and re-create a table while I’m designing it. ...
Since Oracle 8i the Cost Based Optimizer (CBO) is the preferred optimizer for Oracle. In order to make good use of the CBO, you need to create statistics for the data in the database. There are several options to create statistics. ...
Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL Developer. When I do demo’s of building quick ad hoc models in SQL Developer, ...