hi
pls visit this site to how install oracle 9i on unix
http://www.stanford.ed u/dept/itss/docs/oracle/10g/em.101/b12140/toc.htm
With Regards,
Captain
saravanankm
Last Activity: Jan 30 '07, 05:16 AM
Joined: Jul 29 '06
Location: Coimbatore,India
-
Hi
Use Decode Function To divide A column into two column.
hi reshmi ur decode qry Option same Condition. It wil give same result of
two column.
pls Try this condition
SELECT DECODE(emp,'Y', Name) emp_name , DECODE(emp,'N', Name) nomemp_name FROM Table;
With regards,
CaptainLeave a comment:
-
Datbase Level DML Trigger
Hi
I want to trace insert or update operation any table in the database.
the DB contain more then 500 tables if any user try to insert or update
in this DB i wnat to Write user info one log file and also update user info into another database table...
pls help Me it's urgent...
With Regards,
Captain -
Hi
pls visit this site may help u!
[URL=http://www.iselfschool ing.com/FREE_Oracle_Tra ining/03_DBAs/01_Fundamentals/lesson11.html]
this site contain more info about funda I.
With Regards,
CaptainLeave a comment:
-
Hi
Thanks!!!
With Regards,
CaptainLeave a comment:
-
Hi
If U Want More Information to visit this site helpfull for Date Functions.
http://www.unix.org.ua/orelly/oracle/prog2/ch12_02.htm
With Regards,
CaptainLeave a comment:
-
Hi
Try This May help U!
UTC Time Zone Same as GMT time Zone.
select to_char(new_tim e(sysdate,'PST' , 'GMT'), 'MM/DD/YY HH:MI AM') FROM dual;
With Regards,
CaptainLeave a comment:
-
Hi
A generic protocol adapter error occurred.
Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
For further details, turn on tracing and reexecute the operation.
With Regards,...Leave a comment:
-
hi
the following sites are usefull Notes For perl Prog.
http://www.ee.surrey.a c.uk/Teaching/Courses/Perllab/prep/index.html
http://www.peak.org/~regan/perl/
http://www.perl.com/pub/a/2000/10/begperl1.html
pls visit it may Help U!
With Regards,
CaptainLeave a comment:
-
Hi
it's possible to use an IF clause inside a SELECT statement.
Well, not exactly. But you can use CASE to do the exact same thing.
SELECT column1, column2,
??CASE column3
????WHEN Condition1 THEN Action1
????WHEN Condition2 THEN Action2
????WHEN Condition3 THEN Action3
????ELSE Action4
??END AS Name
FROM Table_name
With Regards,
Ca...Leave a comment:
-
Hi
Clearly i don't Know But I think this may error occur in open cursor
in this command is problem
open socceraway_curs or(v_hometeam);
With regards,
Captain...Leave a comment:
-
Hi
U can't Rollback Above two insert Command Because Drop is Auto comit DDL
Command.
This is Possible to Rollback insert Command
CREATE OR REPLACE procedure temp
as
begin
insert into PRATIK values(4);
EXECUTE IMMEDIATE 'DROP TABLE PRATIK';
insert into t1 values(1);
insert into t1 values(2);
insert into PRATIK values(4);
EXCEPTION
WHEN OTHERS...Leave a comment:
-
Hi
Ans: False
Because Sequence field May Use Non Primary columns Also.
Using Sequence Cycle we can repeat Same value More then one time.
With Regards,
Captain...Leave a comment:
-
Hi
Select qry Minimum two Clause Needed
For Ex Select & From clause
select distinct (5+6) from dual;
Or
Select distinct (xxxx + yyyyy) from Table_name;
With Regards,
CaptainLeave a comment:
-
Hi!
pls Visit This Site May Help U!
http://www.mydatabases upport.com/oracle/administration/oracle-database-administration-ora-7445-error.html
With Regards,
CaptainLeave a comment:
-
Hi
pls Check Ur where cluse Condition
CREATE or REPLACE PROCEDURE OGS_EXP.custmr (custmr out char(6)) AS
SELECT ID_CUSTMR FROM ogs_exp.t_bkng_ m where id_custmr = custmr;
end;
With Regards,
CaptainLeave a comment:
-
Hi!
pls Visit This Site May help U.
http://www.dba-oracle.com/art_proc.htm
http://www.ics.com/support/docs/dx/1.5/tut6.html
http://www.devshed.com/c/a/Oracle/Oracle-Stored-Procedures/2/
With Regards
CaptainLeave a comment:
-
Hi
Pls visit this Site Oracle database Migration Information
http://dba-services.berkel ey.edu/docs/oracle/manual-9iR2/server.920/a96530/migintro.htm
I hope this is helpful for U!
With Regards
CaptainLeave a comment:
-
HI
Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.
With Regards
Captain...Leave a comment:
-
Simple Select Qry
Hi
I have one table That Contains 5 Records.
i Need to select first column to Print column Format...
For Example
table : Student
Fields are
1. Roll No
2. Student Name
3. Subject
4. Mark
data Stored like this
Roll No Name Subject Mark
---------------------------------------------------------------
101 ...
No activity results to display
Leave a comment: