Hi, I've enabled auditing and running:
SELECT username,
owner,
obj_name,
action_name
FROM dba_audit_trail
ORDER BY timestamp;
I get the select statements in the...
Dear Team,
I have 2 tables Table1(Id,Name) and Table2(Id,TableId,Name)
Table1
Id TableId Name
1 1 Apple
2 2 Mango
3 3 Banana
4 3 Gra...
Hello Gurus,
I have couple question regarding the date conversion. One of the date column i am using has the date in the fomat '20081127' and the data type is'number'. I am Using the code
Co...
why is fd2 and fd3 here a partial dependency? my understanding is that in a partial dependency if I remove an attribute from the left hand side of the dependency then the dependency would stil...
Hi , I have the two tables shown in the image, I need to query these tables to return totals of quantity_required for the component codes press and cut, where if a works_order has press as a ...
I have a piece of trial software that requires use of the Borland Sample Database which is normally kept in the "Program Files\Common Files\Borland Shared\Data" folder. I do not have that fol...
I have a database with three tables so that users can write their comments about a specific issue.
The tables are as follows in the format of table_name(column_name,....):
1:users (user_id...
I want to change a column type in a populated table in MSSQL 2005 from smalldatetime to datetime. It seems to work OK when I do it on a copy of the table but I am wary doing such actions and w...
Hi,
I have created a table below, num is the primary key.
fstName and lstName are employee names and are a composite key for the employee table (not shown)...no two employees can have the ...
At the moment I pass information via a URL, for example
index.php?data=this&data2=that
Then using $_GET I get those values and store them in my SQL DB.
Though I do not want the user ...
I've been doing SQL for the last 3 years and did have some classes on database theory and usage but for some reason I can't figure this one out.
I have a table of Products, a table of Categ...
I am receiving an error message when I attempt to update a table using an append query. This has been working but I recently added functionality to add data for this year and had to add a year...
I have a SQL 2000 database that will soon have new empoyee numbers installed by the software vendor. The name field associated to the new number has the names entered as firstname middle initi...
I am trying to modify a Paradox dbase that someone else built. I know a little about databases in MS Access and understand the basic concepts but know very little at all about how to do it in...
Ok - mysql newb here.
I have two mysql tables identical in structure that contain different data. I simply want to merge the two tables so they have a unique id. I get duplicate entry error...
Hi All,
Some end users want to input the # sign as a value in varchar (sql server) and text (access).
Are there any gotchya's that come along with this or anything to be aware of?
Tha...
I have a database and an asp web app. The web app has a dropdown that puts the results in sequetial order however I would like to see it in asending order. I know i could make my asp code to...
I creating a financial data driven applciation. I am trying to decide if I should use a mySQL DB or an Oracle DB. What are the differences between the two security wise and ease of security ...
Have loaded foxpro 2.6 on pentium computer and it doesnot start up. Tried patch from microsoft (both of them) neither worked and the alternative site recommended by expert is not available. An...
when I took a backup of a db it is arround 25 gb and i tried to restore this in aonhter DB but it throwed an error no suffiecient space but my free space is arround 40gb then i cheked the the...
Our production server resides on a 64bit-3 nodes servers. For some reason, even with the help of Microsoft, we were not able to find out the culprit in all the applications. The weirdest thi...
I am preparing for interviews and wondering to see if I can collect some consolidated knowledge on database indexes ?
Just wondering if some one can answer or point to appropriate resources...
Greetings.
i am looking for a way to filter the results on a table based on a column uniqness.
What i am saying is as you see on the example below , the [ID2] may be multiple times
on the...
How do i add a currency symbol to this statement?
Cast(Referencepricing as Decimal(20,2) as 'Reference
Hello experts,
My database 'LeoAlpha' became too large. So I detached LeoAlpha and copied the files LeoAlpha.mdf and LeoAlpha_log.ldf aside, then re-attached LeoAlpha and deleted enough recor...
