Database
In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?
- 873 views
- 1 answers
- 0 votes
You have just compiled a PL/SQL package but got errors, how would you view the errors?
- 909 views
- 1 answers
- 0 votes
How can I access Microsoft Office? Please help as soon as possible.
- 1067 views
- 3 answers
- 0 votes
Warm greetings to all,
I am posting here an issue regarding MS Access. I pasted below an error message that I encountered while I was trying to run a query. When the query failed, I received the error message below.
Microsoft Office Access
Circular reference cause by alias ‘Dist-CC’ in query definition’s SELECT list.
I tried to review all the procedures that I made before I encountered the said error message. I have no idea about what went wrong which caused the error. This was also my first time to encounter this error.
Please help me solve this issue.
- 3881 views
- 1 answers
- 0 votes
Great day to all,
My post here is an issue about MS Access error. When I tried to insert a new record in a table, and this table has an auto number field, an error message appeared on my screen.
Please see below the error message I pasted.
Microsoft Access
The changes you requested to the table were not successful because they
would create duplicated values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove the
- 1555 views
- 3 answers
- 0 votes
Hi MS Access Savvy,
I am asking for some comments on this error message that I am posting here. I meet this error every time I update my database.
Microsoft Office Access
- 3926 views
- 1 answers
- 0 votes
Hello people,
I am posting here the problem I encountered when I tried to open the Visual Basic Editor in a Microsoft Access database.
The Visual Basic for Applications project in the database is corrupt.
I haven't experienced this error message ever since. That is why I'm having a hard time solving this issue. Please help me fix my file if indeed it is corrupted.
Is there any chance to get back my file?
I am very worried about this error that I met.
Please share your thoughts on my problem.
Thanks.
- 1640 views
- 1 answers
- 1 votes
It is believed that Classical SDLC is not suitable for Data warehouse environment. In your point of view why is it not suitable? Secondly what changes do you suggest to be made in Classical SDLC to make it suitable for data warehouse? Give reasons to support your ideas.
- 1656 views
- 1 answers
- 0 votes
You are given the following data.
Patient No, Patient First Name, Patient Last Name, Patient Address, Gender, Tel No, DOB, Marital Status, Date Reg., Next of Kin Name, Relationship, Next of Kin Address, Next of Kin Tel No, Local's Doctor's Name, Clinic No, Doctor's Address, Doctor's Tel No.
Normalize the given data into 1st then 2nd and 3rd normal form. Give justification of conversion into 1st then 2nd and 3rd normal form and the anomalies because of which you transformed it into another normal form.
- 856 views
- 1 answers
- 0 votes
Hi,
I am a new user of SQL server 2000 Home Edition. Please any one tell me procedure how can I install it in my computer?
Thanks.
- 1218 views
- 2 answers
- 0 votes