hi dear all,
i have table which reference with multiple other tables
and it do not have ON DELETE CASCADE so now i want to delete this row without disabling the constraints.
delete from account where account_no=201
i am trying the above query it give me the following errors
Error starting at line : 13 in command -
delete from account where account_no=201
Error report -
SQL Error:...
Rohullah
Last Activity: Jun 18 '17, 02:14 PM
Joined: Mar 25 '10
Location:
-
How to delete a row with all foreign keys
-
How to get subtotal after every 20th row in sql server
dear all,
I have 2000 rows in my table and i want to have subtotal after every 20th row could anyone help me i do not know how to do it.
thanks in advance. -
How to sum two fields value in third field in oracle apex
Dear all,
please guide me if anyone know , i have salary and commission columns in my table and now i want to sum salary with commission in a third field or texbox in oracle apex please help me how to do it.
thanks in advance. -
Dear Luuk,
i want to select all those record from a table whose 20 days are completed in the system, means ofter every 20 days the view should select those rows from the table whose 20 days are completed,
I have done as bellow but i am not sure its okay or not.
...Code:declare @Date tinyint set @Date=day(getdate()) select @Date,* from BillBoards where day(@Date)-day(Billaboards.BillBoardDate)=20
Last edited by Rabbit; Apr 22 '14, 03:14 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
How to get every month 20 date from a table
Dear All,
I want to create a view and the view only should get those rows from a table which a dateColumn has in this format(MM/DD/YYYY) this date(XX/20/XXXX) date for every month if the date is 21 in the view should not show that record, means for only one day the view should hold/keep the record.
thanks in advance. -
Hi Dear ThatITdude,
i have changed my oracle DB Character set to (AL32UTF8) as bellow but again the arabic characters are not appears right, it is appears as (??????) in sqlplus.
so please guide me how to do it ,thanks and regards
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1292036 bytes...Leave a comment:
-
How to store Arabic Characters in ORACLE database?
Hello All,
I am new to oracle database , please guide me how to configure my oracle database to store
Arabic Characters, please tell me all parameters that i should set to what value, step by step.
Thanks in advance.
Looking forward for your kindly Replay.
Best Regard
Rohullah Amiree -
how to delete archivelog automaticly
Hi all
i want to delete 10 days old archivelog automaticly from my oracle database how to do it please hlep me.
thank you in advance. -
how to open Recovered files?
Hello all
Same data was delete from me, and i Recovered it back by using GetDataBack 3.30 version,
the file format is ISO which i recovered now the file size is zero 0KB,
when i recover other file its OK but the file which i need its Size appears 0 kb .
What process should i follow to recover my data back.
Please help me, i really need yours help.
looking foreword for ur replays.
thanks in advance... -
how to undo system restore image?
Hello
every one
i have recently restore system image in windows 7 but, i did not backup my files so i lost them they are very important for me.
I try to recover them by using different Recovery software but it actually did not work.
so please and please help me what should i do.
Thanks million time in advance. -
How to play Gif file in oracle form 6i/
Hello
I want to display Gif file in oracle form6i,i am trying by using PictureBox as following.
I have pictureBox name='PIC'
And i have Button name='button1'
I set ImageFormat property='GIF'
this is my code
--------------------
READ_IMAGE_FILE ('D:\Animation\ loading_animati on.gif','GIF',' BLOCK2.PIC');
--------------------
its load the gif image but does not animating.... -
The dependency service or group failed to start/
Hello
when I install SQL SERVER 2008 standard Edition
it give me the following error
The Dependency Service or Group Failed to Start.
I use windows 7 Ultimate 32-bit(6.1,build 7600)
Please help me
Thanks. -
Hello Dear
I try the above method but its again give the following error
---------------------------------------
SQL> show error;
Errors for TRIGGER EMP_TRIG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/13 PLS-00103: Encountered the symbol "P1" when expecting one of the
following:
:= . ( @ % ; immediate...Leave a comment:
-
How to call store procedure from DB trigger in oracle 10g?
Hello Everyone
I want to call store procedure from DataBase Trigger
how to call it.
i tried as following but it give me error.
For example This is my Procedure
----------------------------------
...Code:CREATE OR REPLACE PROCEDURE P1 IS CURSOR C1 IS SELECT EMPNO,ENAME FROM EMP; V_EMPNO NUMBER; V_ENAME VARCHAR2(20); BEGIN OPEN C1; LOOP FETCH C1 INTO
-
How to Close One Window from another window in oracle form6i?
Hello
For Example i have two window (window1 and window2)in oracle form6i
i want active one window at a time
for example window1 is active and i want to active window2 then
window1 should automaticly Deactive.
how to do it?
please Help me.
thanks. -
How To Call .Swf file into oracle form6i?
Hello
How to Call.Swf file into oracle form6i?
Looking forword.
Tanks in advance. -
How to solve stock calculation Error?
Hello
I have to two tables as following
-----------------------------
create table orders
(orderid number primary key,
orderdate date,Ename varcarh2(20),
ItemID number,ItemName varchar2(20),
Itemtype varchar2(20),to ns number);
sql>table created
create table companystock
(Itemid number,ItemName varchar2(20),
Itemtype varchar2(20),to ns number);
sql>table... -
How to drop primary key referenced to other foreign key?
Hello
I want to Drop a primary key Referenced to other foriegn key.
I try the following method
---------------------
alter table Stock drop constraint SYS_C005460;
---------------------
But it give me The following Message.
ORA-02273: this unique/primary key is referenced by some foreign keys.
How to drop it PLZ gime the Best Answer.
Lookin forword,Thank you in Advanc... -
They are not linked,Send me Passible answer Plz.Leave a comment:
-
How to calculate Stock information?
Hello Sir
I have Error with the following tables one is [INCOME] And one is[Stock].
Income table Columns.
Date ItemID ItemType Amount DriverName TruckNo
---------------------
Stock Table columns.
Itemid ItemName ItemType Amount
-----------------------------------
Now when i enter record to income table
and income itemid not = to stock itemid then
itemid,itemName ,ItemType,Amoun t...
No activity results to display
Leave a comment: