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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.