Hello
Thanks for the reply.
I have tried Script Control, but using this I can evaluate only " 10 + 20 + 30" not "a + b + c".
Regards
Reshmi...
Reshmi Jacob
Last Activity: Mar 19 '08, 04:54 AM
Joined: Sep 15 '06
Location:
-
Evaluate a formula given as string
Hello.....
In my program I have 3 variables, say
a = 10
b = 20
c = 30
I have a variable as string
vformula = "a + b + c"
I have to evaluate the formula and get the result as 60
ie ; myanswer = SOMEFUNCTION(vf ormula).
I tried using Scriptcontrol.E VAL function. But I can use only " 10 + 20 + 30".
Also, when I... -
DLL for opening connection(Oracle)
Hi all
I just want to create a DLL in which I want to open a conn to an Oracle Database which can be used Public inside any program.
In the main Program I will use
OPENDB("C")
In the DLL, this has to be accepted and process the function OPENDB(CType)
and return true if the Connection is open (i need to use the connection too...)
The Variable CType is just... -
Install Oracle 8i on Vista - Processor :Intel Core2 Duo
Hi all
I am trying to install Oracle 8i on OS : Vista ; Processor :Intel Core2 Duo in my laptop. Upto an 87% of installation is complete when it raises an error, 'Problems occcured with jrew.exe. Cannot Identify'. And only button u can see is CLOSE in the error window, once you click on it Installation program is exitted. Can anybody help me in this?
Thanks in advance
Regards
Reshmi -
Privilege for AFTER LOGON ON DATABASE
Hi
I have created a trigger for identifying the users lgin history :
create table logon_tbl (who varchar2(30), when date);
create or replace trigger trg_logon_db
after logon on database
begin
insert into logon_tbl (who, when) values (user, sysdate);
end;
But the problem is, it is showing INSUFFICEINT PRIVILEGES. Which is the privilege... -
Try lik this
...Code:SELECT B.BRA_CODE "Branch Code", B.BRA_LOCATION "Branch Location", A.ACCTYP_CODE "Account Type Code", AT.ACCTYP_DESC "Account Type Description", DECODE(SUM(NVL(A.ACCNT_BAL, 0)),NULL,0,SUM(NVL(A.ACCNT_BAL, 0))) "Total Current Values" FROM ACCOUNT A, ACCTYPE AT, BRANCH B, CUSTOMER C WHERE A.CUST_NO = C.CUST_NO AND
Leave a comment:
-
REDO Log file corrupted
Hi
My problem occurs in a network with 40-50 systems working from a server.
Current users will be kicked out with "ORA-01092: ORACLE instance terminated. Disconnection forced", and users trying to log on will get "ERROR: ORA-03114: not connected to ORACLE" I checked the alert file and understood that error is coming while accesing REDO Log files...
From Alert.LOG===>
Thread... -
Hi
Is this the corruption of REDO log file. How can I rectify it
ReshmiLeave a comment:
-
Hi
In the ALERT LOG I found...
Sat May 05 11:15:42 2007
alter database open
Beginning crash recovery of 1 threads
Sat May 05 11:15:43 2007
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 30112 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 3.LOG
Sat May 05 11:15:43 2007
Thread recovery: finish...Leave a comment:
-
Hi
Thanks, i was seaching for Alert.LOG !!!
Thaks again
Reshmi...Leave a comment:
-
ORA-01092: ORACLE instance terminated. Disconnection forced
Hi
I am facing this error while working with a database, about 40-50 persons are using this DB.
I searched thru the sites to refer these error. They are saying t look into ALERT.LOG. I searched the entire server but couldn't find ALERT.LOG. Can any body help in finding this file???
Also, why this happens??? In the server, I have One database, 2 Users, 1 Listener, 1 Service Name.
Anybody... -
Hello
SELECT All_TRIGGERS.*, DECODE(STATUS,' ENABLED','VALID ','INVALID') STATUSS
FROM All_TRIGGERS WHERE TRIGGER_NAME ='TRIGGER'
Try, this may help you
Reshmi...Leave a comment:
-
Outer Join _ SQL
Hello
I have 3 Tables
1. Acc
------------------------
CoCode
AccCode
AccName
2. Trn
------------------------
CoCode
BrCode
AccCode
Amount
3. Opening
------------------------
CoCode
BrCode
AccCode
OpenBalance
RELATIONS :-
* Trn.CoCode = Acc.CoCode And Trn.AccCode = Acc.AccCode... -
Log On Database Trigger :ora-00406 :
Hello...
I created a trigger :
CREATE TRIGGER LOGON_DB
AFTER LOGON ON DATABASE
BEGIN
IF SYSDATE >= TO_DATE('28-FEB-2007') THEN
UPDATE COMPANY_MST SET FA_CHK='BLOCK';
END IF;
END;
But when this is compiled error raised....
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
My Oracle Version is...
SQL*Plus: Release... -
Loop thru columns in a Trigger
Hi,
I am creating a trigger which will record the old value of a table when update occurs.
For eg : I have the Table : ITEM
ItemCode Varchar2(5),
ItemDesc Varchar2(30)
I willl write a trigger
CREATE OR REPLACE TRIGGER TRG_ITEMMST
AFTER UPDATE ON ITEM_MST FOR EACH ROW
BEGIN
FOR r IN (SELECT COLUMN_NAME FROM USER_TAB_COLUMN S... -
Hi
You can use
INSERT INTO Table VALUES ('''', value2,...);
to insert a single quotes u replace it with 4 Single Quotes
ReshmiLeave a comment:
-
Which fields are changed on update - History tracking
Hello,
I want to track the changes made to a particular table, ie, if a user initiates an update command, I want to know which values are changed.
I tried with a trigger, it is succesful,but too complicated!!! Any other alternatiive method to let the administrator know which are the changes made and when??
Regards
Reshmi -
Hi
You search for TNSNAMES.ORA file in server's Oracle folder ( D:\Oracle\Ora81 \network\ADMIN) . Open it and you can see the servi9ce name there.
Regards
Reshmi...Leave a comment:
-
Hi
Select constraint-name from USER_CONSTRAINT S where Table_name = 'ABC;
This Query will give you the constraint name. If you want the fields included in forming a constraint , u can use the data dictionary - User_Cons_Colum ns
Select C.Table_Name, C.Column_Name, C.Position , m.Constraint_Ty pe
From User_Constraint s M, User_Cons_Colum ns C
WHERE M.Table_Name=C. Table_Name
and...Leave a comment:
-
Hello
You can use this query :
select count(*) from user_tab_column s where table_name='ABC ';
You can specify ur table name instead of ABC in capital letters...
Regards
Reshmi...Leave a comment:
No activity results to display
Leave a comment: