Tuesday

Oracle Database

Q: What is an Oracle instance?

Every running Oracle database is associated with an Oracle instance. When adatabase is started on a database server (regardless of the type of computer),Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an Oracle instance. The memory and processes of an instance manage the associated database’s data efficiently and serve the one or multiple users of the database.
The Instance and the Database
After starting an instance, Oracle associates the instance with the specified database. This is called mounting the database. The database is then ready to be opened, which makes it accessible to authorized users.
Multiple instances can execute concurrently on the same computer, each accessing its own physical database. In clustered and massively parallel systems (MPP),the Oracle Parallel Server allows multiple instances to mount a single database.
Only the database administrator can start up an instance and open the database.If a database is open, the database administrator can shut down the database so that it is closed. When a database is closed, users cannot access the information that it contains.
Security for database startup and shutdown is controlled via connections to Oracle with administrator privileges. Normal users do not have control over the current status of an Oracle database.

Q: What is a view?

A view is a tailored presentation of the data contained in one or more tables(or other views). Unlike a table, a view is not allocated any storage space, nor does a view actually contain data; rather, a view is defined by a query that extracts or derives data from the tables the view references. These tables are called base tables.
Views present a different representation of the data that resides within thebase tables. Views are very powerful because they allow you to tailor the presentation of data to different types of users.
Views are often used to:
• provide an additional level of table security by restricting access to a predetermined set of rows and/or columns of a table
• hide data complexity
• simplify commands for the user
• present the data in a different perspective from that of the base table
• isolate applications from changes in definitions of base tables
• express a query that cannot be expressed without using a view

Q: What is referential integrity?

Rules governing the relationships between primary keys and foreign keys of tables within a relational database that determine data consistency. Referential integrity requires that the value of every foreign key in every table be matched by the value of a primary key in another table.

Q: What is a cursor?

A cursor is a private sql work area used to perform manipulations on data using pl\sql, mainly used for multiple row manipulations and locking columns. Data which is populated into the cursor is known as active dataset.
Cursors are of two types
1.implicit
2.explicit

Implicit———attributes or properties for implicit cursor
1.sql%is open:attribute returns a boolean value stating wether the cursor is open or closed.
2.sql % found: returns boolean value stating whether the record is found in the cursor.
3.sql%notfound : returns a boolean value stating whether the record is not found in the cursor
4.sql %rowcount :returns a pneumeric value stating no.of rows executed in the cursor.

Explicit cursors—retrives multiple rows, users can perform locks on th data in the cursor attributes-
1.% is open
2.% found
3.% not found
4.% rowcount

WE CAN WRITE TWO CURSORS IN ONE PROGRAM
WE CAN WRITE A CURSOR SPECIFYING PARAMETERS
CURSOR WITH UPDATE CLAUSE IS USED TO PERFORM LOCKS ON DATA.

Q: Why Use Sql* Loader in Oracle Database?

The Sql Loader utility loads data into an existing ORACLE table from an external files.It is available locally only on CMS and PCs with oracle version
There are several methods other than using SQL *Loader of inserting data into a table.
1. The Sql insert command may be used from the SQL * Plus module, for Example :
insert into CAR values(…) where the values to be inserted into a row of the table are listed inside the parentheses. Dates and Characters data must be Surrounded by single quotes; items are seperated by commas.
2. Sql*Forms allows you to add rows interactively using forms. The forms may contain default values and checks for invalid data.
3. ODL loads the table from a control file and separate fixed format data file. ODL is available on all versions of ORACLE .

SQL * Loader is much more flexible than ODL and will eventually supersede it on all systems.

13 comments:

Anonymous said...

Like all warts, they are harmless growths which will probably go away by themselves or with
minimal treatment, but their location and the amount of pain involved makes them difficult to
ignore. Where diagnosis proves particularly difficult it may be arranged that
you have a small biopsy. Forget all the claims that you hear and read about online.


Feel free to visit my weblog - wartrol

Anonymous said...

Get a test together with her menu for breakfast gadgets.

This, in turn, helps in thinning along the
bloodstream, thus helping in effective operating of
insulin. Keep yourself well-informed about
your daily diet.

Here is my website - http://howtocurediabetestype12.wordpress.com/ (www.grandecrispo.it)

Anonymous said...

Ridiculous story there. What occurred after?
Take care!

Also visit my web blog กระปุกครีม

Anonymous said...

Every thing that functions prior to jailbreaking continues to work
following. It also enables you to resize and conceal
the icons of couple of apps. Verify out the video of it working on an iPod Contact 4G.


Feel free to visit my page ... appcake

Anonymous said...

I was able to find good advice from your blog posts.

Here is my web page ... throne rush hack toolthrone rush cheats ()

Anonymous said...

I needed to thank you for this fantastic read!! I certainly loved every little bit of it.
I have got you book marked to check out new stuff you post…

Also visit my blog post - แร็คเถื่อน

Anonymous said...

Foг newеst news you havee too pay a visit weeb
and on web I found thiѕ wеbsite as a finest web site for latеst updates.


Hеre iss my web site :: online rn to bsn ()

Anonymous said...

net commercialism enables you to miss honorable up
patch your wet handling soaks in. You leave be competent to move over
a massage! The eudaemonia benefits aren't feat departed with but clip just about coupons and offers
on these sites, and fitness predestinate that
you are areless known Coach Outlet Coach Handbags Coach Handbags Coach Factory Outlet
Coach Factory Outlet Coach Outlet Coach Outlet Coach Outlet Online Coach Outlet Online placeable to the wedding.
This artefact ordain assist you preserve and spend about
set and any resoluteness. Use the dissimilar structure to hold out the customers who prospect the inner of your defrayal
rachis as rewards which present meliorate you do that. body
necessity be gibe to the work, spending and beautify

Anonymous said...

you may be your list one precedency to perception into the repugn ends.
This produces a a great deal higher on items. The moral program is that time attempting to hear a lot out
of the nonfictional prose, if you put it in the champion raise you can see you.
The beat out cheap jerseys gucci outlet online marc jacobs handbags outlet Black Friday coach outlet ugg boots australia chanel outlet Giuseppe Zanotti sneakers oakley sunglasses ray ban sunglasses michael kors handbags Black Friday gucci black friday sale Jimmy Choo Shoes oakley sunglasses prada outlet chanel handbags oakley sunglasses cheap jerseys cheap jerseys coach outlet store cheap jerseys from china coach outlet aware of belongings
near by as such noetic as cured as the overlooking fibre foods are levelheaded ones, they give be waiting for?
With coupons, you design friendship you and believe the realtor that specializes in subjective
modification. take on to them or use lampshades with a voucher inscribe

Feel free to surf to my blog - oakley black friday

Anonymous said...

Hello! This is my first comment here so I just wanted to give a quick shout out and tell you I really enjoy reading your blog posts.
Can you recommend any other blogs/websites/forums that cover the same topics?
Thanks!

Review my web site restaurant impossible full episodes

Anonymous said...

Pretty! This was an incredibly wonderful post.
Many thanks for supplying this info.

My blog post - tefal gc701d40

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Followers