|
best thing I could suggest is to post some of the code and we'll give you a head start on its conversion
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
Hi,
I'm posting sample table script
CREATE TABLE "DEV"."APP_ID"
( "AID" NUMBER NOT NULL ENABLE,
"ID_TYPE" NUMBER NOT NULL ENABLE,
"CREATED" DATE DEFAULT sysdate NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"UPDATED" DATE DEFAULT sysdate NOT NULL ENABLE,
"UPDATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE,
PRIMARY KEY ("AID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPLICATION_DATA" ENABLE,
FOREIGN KEY ("ID_TYPE")
REFERENCES "DEV"."ID_TYPE" ("ID_TYPE") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPLICATION_DATA" ;
CREATE OR REPLACE TRIGGER "DEV"."T_APP_ID"
BEFORE INSERT OR UPDATE ON APP_ID
FOR EACH ROW
BEGIN
:new.updated := sysdate;
:new.updated_by := username;
if inserting then
:new.created_by := username;
end if;
END T_APP_ID;
/
ALTER TRIGGER "DEV"."T_APP_ID" ENABLE;
|
|
|
|
|
CREATE TABLE App_ID
(
aid INTEGER PRIMARY KEY NONCLUSTERED,
id_type INTEGER FOREIGN KEY REFERENCES dev.id_type,
created DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
created_by varchar(30) NOT NULL,
updated DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_by varchar(30) NOT NULL,
)
drop table app_id
been a bit too long since I've done Oracle to remeber triggers so here an msnd refernce link triggers
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
so we have to go with manual process if we don't have oracle database.
|
|
|
|
|
Also Oracle offers free versions of their engine for developers - get one. Then get that database with those scripts, and then use a conversion tool as already suggested.
|
|
|
|
|
Thanks bhiller,
I'm downloading it. but it seems to be a huge file.
|
|
|
|
|
Hello I have been trying to learn c# and accessing ultralite I have found the link here 10 Steps to Creating a Windows Mobile Database Application Using .NET and UltraLite 10[^] Which has helped i got it working but what im trying to figure out is how to add a listbox that is controlled by the combobox. What would happen is I select say tom than the list box displays the address.I cant seem to get anywhere with it my previous coding experience is with html and vbscript.
Any help would be appreciated or if you can point me in the right direction
Thank You
Aaron
|
|
|
|
|
Not a database related question, more a C# question.
What you need to do is Handle the TextChanged or ValueChanged event of the ComboBox. In the event handler, populate the ListBox with the required data from your database etc.
Steve Jowett
-------------------------
Real Programmers don't need comments -- the code is obvious.
|
|
|
|
|
hi guys
i delete a column in a table UNWITTING
how can i restore my mistake
and retrieved my deleted column
|
|
|
|
|
Ctrl Z ?
How's the new job?
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
If you do not know how to help, shut up.
And provided you can read and comprehend
"Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid."
SG
Aham Brahmasmi!
|
|
|
|
|
SimulationofSai wrote: "Insults, slap-downs and sarcasm aren't welcome.
Yes they are... as long as they're directed at someone else.
|
|
|
|
|
You need to develop a sense of humour and read earlier threads, ass hat.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
if it had data in it then restore from backup.
As barmey as a sack of badgers
|
|
|
|
|
You can't per se, the data is gone.
However as Simon said you can restore from the last backup. S??? happens, that's what backups are for.
If this is a production DB on the otherhand, s??? should rarely happen to them, which means an awfull lot of arselicking would be required.
If there are no backups, divert blame to the DBA as s??? happens and that's what backups should be for.
If you are the DBA, and no backups have been performed, and this was the dev environment, copy the production environment to dev.
If you are the DBA, and no backups have been performed, and this was the production environment find the nearest exit and polish your resume.
Good luck!
|
|
|
|
|
Sorry I did not see this sooner, so this is too late.
Depending on your disaster recovery model you could do a point in time restore from your backup. This would mean you need full recovery mode, and using the transaction logs.
|
|
|
|
|
If this is production AND you have a backup, you may not want to restore over the top of a production database. you can instead restore to a new database, then add the column allowing nulls, use an update query to put the data back leaving anything in the other columns unchanged. depends on the nature of your data and environment.
|
|
|
|
|
hi guys
when i was tring to restor my db
i faced with this error
"the execution permission was denied on the object sp_enum_sqlagent_subsystems,database msdb,schema dbo-error 229"
please help, my job is in danger
i use sql server 2008
|
|
|
|
|
|
didi you know you are so cute and funny?
ha!ha
|
|
|
|
|
And? That's the first thing you do with an error message if you don't understand it.
|
|
|
|
|
haha that is sweet man! I didnt know that website existed.
|
|
|
|
|
|
This may help.[^]
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
or this[^]
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
