answersLogoWhite

0

Oracle Database

Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.

690 Questions

Will there be another book after the curse of deadman's forest in the oracles of delphi keep series?

yes I read it. it's a really good series you should definitely read them. can't wait for the fourth.

Do you have inner join command in oracle?

yes, we do have inner join command in oracle. Inner Join is used to combine related tuples from two relations.It allows to evaluate a join condition between attributes of the relations on which join is undertaken .

How cas we allow for each user to have 3 concurrent sessions on orcle?

This can be done by using a "profile"

To implement a 3 session hard limit for each user in the database, perform the following:

Login to the DB as SYS via SQLPlus

Once there run the following:

alter system set RESOURCE_LIMIT=true scope=both;

create profile sesslimit limit sessions_per_user 3;

For each user you wish to implement the new limit on you

will need to do the following:

alter user <username> profile sesslimit;

What is the Slogan for oracle?

Information driven(PRESENT)

For the Oracle Database: "Can't break it, can't break in"and "Unbreakable"

As of 2008: "The Information Company"

As of 2010: "Software. Hardware. Complete."

As of late 2010: "Hardware and Software, Engineered to Work Together"

What is oracle pft?

Oracle PFT = Oracle Profitability Manager which is a tool used in the financial end.

Why must create user in oracle todo your work in oracle?

A user in Oracle corresponds to a schema.

Objects, such as table and indexes, must exist within a schema.

Without creating a user/schema, use of the database will be limited to the built-in schemas and objects, such as the one-row DUAL table and standard PL/SQL packages.

What is a char?

A char is a time, a turn or an occasion, an odd job, or a woman employed to do housework.

How do you retrieve the target path of any existing shortcut such as a lnk file in Visual Basic?

Here is how to open a Windows Shortcut file Using VB6. This is a safe and documented method.

Create a New VB6 Project

In the Project References Add "Windows Script Host Object Model"

Place a Command Button on the form named CommandButton1

Click on CommandButton1

Private Sub CommandButton1_Click()

Dim Oshell As New WshShell

Dim Osh As WshShortcut

Dim Fn As String

Dim Otarget As String

'Set the path and file name of the shortcut

Fn = "C:\shortcut path\shortcut filename.lnk"

'

' If the shortcut file is existing, it will open the existing file

'

Set Osh = Oshell.CreateShortcut(Fn)

Otarget = Osh.TargetPath

'

' Using the Watch window see the other properties of Osh object

'

End Sub

Why did she dump you?

She might have dumped you for something as stupid as cheating, in some cases maybe you just didn't talk to her enough, it usually depends on the people and the situation. Maybe its as simple as she just didn't feel it was right going out with you, the sparks were gone.

hey someone else here or maybe she just hated u idk get use to it kk (im a girl so should know)

Write a program of even or odd in plsql?

BEGIN

FOR I IN 1..100 LOOP

--if the number is divisible by 2 then it is a even number.

IF MOD(#,2)=0 THEN

--display the number.

dbms_output.put_line(I);

END IF;

END LOOP;

END;

elementFontfont-familyfont-sizefont-stylefont-variantfont-weightletter-spacingline-heighttext-decorationtext-aligntext-indenttext-transformwhite-spaceword-spacingcolorBackgroundbg-attachmentbg-colorbg-imagebg-positionbg-repeatBoxwidthheightborder-topborder-rightborder-bottomborder-leftmarginpaddingmax-heightmin-heightmax-widthmin-widthoutline-coloroutline-styleoutline-widthPositioningpositiontopbottomrightleftfloatdisplayclearz-indexListlist-style-imagelist-style-typelist-style-positionTablevertical-alignborder-collapseborder-spacingcaption-sideempty-cellstable-layoutEffectstext-shadow-webkit-box-shadowborder-radiusOtheroverflowcursorvisibility

What is the use of v in oracle?

The only instance I've seen of using v as a function in the Oracle database is via their Application Express (aka Apex) web application development system. In Apex, the v function allows you to get a value for any variable in your Apex application. These variables are known as either page items or application items, depending on their scope.

You can use the v function within procedural code within your Apex application, but more importantly, you can use it from compiled procedural code that you call from Apex. That is, the v function needs to be called from the Apex environment to know where to get the item value from.

Syntax is: l_app_id := v('APP_ID');

What is the use of spfile and init.ora in oracle?

init.ora and SPfile both contain information about DB parameters. The database cannot start without an INIT.ORA but can start without an SPfile. An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora) Init.ora is saved in ascii text format whereas the SPfile is saved in a binary format. If both files exist , the database reads the SPfile first before processing the init.ora. Oracle Guru's step in and correct if necessary .......... :) , Lekarshi

Are serial schedules recoverable or cascadeless?

It depends. A serial schedule is one in which the operations of one transaction begins after the operation of another.. that is for example there are 5 operations in Ti(Oi1,Oi2,Oi3,Oi4,Oi5) and 4 operations in Tj(Oj1,Oj2,Oj3,Oj4) the schedule is :

Oi1,Oi2,Oi3,Oi4,Oi5,Oj1,Oj2,Oj3,Oj4 OR Oj1,Oj2,Oj3,Oj4,Oi1,Oi2,Oi3,Oi4,Oi5

But to check if a schedule is recoverable we need to check whether for each pair of transactions ,Ti and Tj - such that Tj reads a dataItem previously written by Ti - Ti commits before Tj. If so it is recoverable.

All cascadeless Schedules are also recoverable Schedules

How do you rename a datafile in Oracle?

â–º Rename a Datafile in Oracle(10g):-SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf

8 rows selected.

SQL> alter tablespace msb read only;

Tablespace altered.

SQL> select TABLESPACE_NAME, status from dba_tablespaces;

TABLESPACE_NAME STATUS

------------------------------ ---------

SYSTEM ONLINE

UNDOTBS1 ONLINE

SYSAUX ONLINE

TEMP ONLINE

USR01 ONLINE

USR02 ONLINE

TEMP01 ONLINE

INNER ONLINE

ASM ONLINE

MSB READ ONLY

TEMPORARY ONLINE

TABLESPACE_NAME STATUS

------------------------------ ---------

TSPUNDO ONLINE

12 rows selected.

SQL> alter tablespace msb offline;

Tablespace altered.

============================================================

Work on OS level:-

[oracle@abab-YYY-XXX abab]$ CD /u01/app/oracle/product/10.2.0/oradata/nisi/

[oracle@abab-YYY-XXX abab]$ ls

asm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbf

m123.dbf redo2.log system.dbf usr01.dbf

redo3.log temporary.dbf usr02.dbf

[oracle@abab-YYY-XXX abab]$ cp m123.dbf mmm.dbf

[oracle@abab-YYY-XXX abab]$ ls

asm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbf

m123.dbf redo2.log system.dbf usr01.dbf

mmm.dbf redo3.log temporary.dbf usr02.dbf

[oracle@abab-YYY-XXX abab]$

============================================================

SQL> alter database rename file

2 '/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf'

3 to

4 '/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf';

Database altered.

SQL> alter tablespace msb online;

Tablespace altered.

SQL> alter tablespace msb read write;

Tablespace altered.

SQL> select name, status from v$datafile;

NAME STATUS

------------------------------------------------------------ -------

/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf SYSTEM

/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf ONLINE

8 rows selected.