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"
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.
Which transformation is used to join flat file and oracle source in informatica?
lookup transformation
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
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-radiusOtheroverflowcursorvisibilityWhat 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?
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.
How do you eliminate records with easytrieve?
If you have a JOB statement, you can have a GO TO JOB statement. That will cause the next record to be read.
What programming language is Oracle discoverer Plus written in?
Oracle Discoverer Plus is primarily written in Oracle's proprietary language, PL/SQL, which is used for database programming. Additionally, it may utilize other technologies like Java and HTML for its web-based interface. Overall, its architecture combines various languages to deliver its reporting and analysis capabilities.
What is the structure of logical argument?
An argument is a connected series of statements to establish a definite proposition.
3 stages to an argument: Premises, inference, and conclusion.
How do you create a complex view in oracle?
1. create table vi(n number);
insert into vi(1);
insert into vi(2);
insert into vi(3);
insert into vi(4);
2. create table bh(n number, name varchar2(10));
insert into bh(1, 'vij1');
insert into bh(2, 'vij2');
insert into bh(3, 'vij3');
insert into bh(4, 'vij4');
create view v1 as select vi.n, bh.name from vi, bh wherer vi.n=bh.n;