Search results for query: *

We mistakenly created a new key as primary key even though we had a perfect candidate key for that. Now we want to delete that and make the candidate which is already a field on our table the primary key. Problem we did not want to delete that until is visible via erd. My question is, can we...

I decided to resend this thread because I was struggling making my point clear. I will like to see my output formatted like this: t.lname #Unsigned t.id t.fname t.spec t.docid Jim 91 13 eddy 15 30 This is what I have: select distinct t.lname...

I am trying to get a total count of certain employees. I am using select colum1..columnN, count(*) from emp where empno = P_empno group by rollup(colum1,columnN) Say for instance there are 30 employees in dept 10, I want it like: ename dept total king 10 3 Right now I am getting...

any time I run my report, i use date ranges. eg select * from emp where begin_date between to_date('01/01/1986,'mm/dd/yyyy') and to_date('12/30/1999,'mm/dd/yyyy'). Now, how can I set the begin_date to display at the top of the form like this: December, 1986 and then report follows? thanks!

I am trying to perform an action a forms field after an insert or update, depending on the situation. I have this code that is not working. Can anyone please look into this for me? I assumed it to be a pre-insert/pre-update trigger. My other problem with this code is understanding how to...

Has anyone been involved in deploying dev2000 (forms, reports) application to windows (not web). If yes, PLEASE, PLEASE tell me the steps, if possible. I hear names like checkmap, oinus.msb, PRD etc. They are so novel to me that I don't even know where to start. I have developed the forms and...

to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik

to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik

Can someone please tell me why this code is not working? CURSOR c_1 IS SELECT call, call2, call3, call4 FROM mytab WHERE ((caller = 'I') and (call_in = ' ' OR call_in is null) and (call_referrer = 'A' OR call_referrer = 'B' or...

During a conversation with a coworker, I was told that it is BETTER to use varchar2(1) than to user char1(1). Can someone please shed some light into this. Thanks in advance. zik

Can anyone help, please! I have been trying to connect to an Oracle or Access databases using http://127.0.0.1 but I cannot get thru even though I have already created dsn using odbc. The most frustrating part is that I had someone actually get it to work for me but then my win2000 crashed and I...

I have a requirement says that there three tables in different Oracle databases that need to be consolidated into one table. In order words, all data in those tables will to be moved into one table in a data warehouse set up. Can anyone give a head start on this. I am sorry that I don't have any...

I have a requirement says that there three tables in different Oracle databases that need to be consolidated into one table. In order words, all data in those tables will to be moved into one table in a data warehouse set up. Can anyone give a head start on this. I am sorry that I don't have any...