PL/SQL – Attribute to test not null and can take specific value instead
Hi Experts, How can we make a check on an attribute not null but can take – rather I have address 3 which can’t take null instead – would be fine how this can be check n PL/SQL procedure

Answer Question   |  February 9, 2009  11:13 AM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure

In-Memory Database
What do you mean by In-Memory Database? Is it like loading of database data along with application? Please explain me how the In-memory database get loaded along with the application.

Answer Question   |  February 17, 2009  8:38 AM
Database management, In-Memory Database

What questions should I expect for a Network Engineer interview?
Hi what questions should i expect for a network engineer interview

Answer Question   |  September 11, 2010  4:31 PM
Interviews, IT careers, IT jobs, Network engineering, Network Engineers, Sample interview questions

Change Management and Active Directory?
I have to start an IT course tomorrow and i want to study what the topics are; i was just wondering if anyone could elaborate on these IT terms for me: “Change Management & Active Directory

Answer Question   |  February 9, 2009  11:16 AM
Active Directory, Change management, IT careers, IT education, IT training

How to block AS/400 users from using WinSQL
How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with any [...]

Answer Question   |  November 4, 2009  6:40 AM
AS/400 administration, AS/400 security, AS/400 user permissions, iSeries Access for Windows, ODBC, WinSQL

ASP.NET and Multiple Access Databases Open
Dear Colleagues Please could you help me? Is it possible to have an ASP .Net Web application with multiple (7) large MS Access 2000 databases open simultaneously. When I heard this I was surprised because there could be dozens of users each using up to 7 large and disparate Access databases simultaneously. Please help? Thank [...]

Answer Question   |  February 9, 2009  10:13 PM
.NET applications, ASP.NET, Concurrent database connections, Concurrent users, Database connectivity, Microsoft Access, Multiple databases, Web development

Crystal Reports last twelve months
I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process [...]

Answer Question   |  March 13, 2009  10:00 PM
Crystal Reports, SQL Database, SQL queries

How to find a string in all columns of a table
I want to search for a string for example “POLARIS” in all the columns of a table ? How to find the string using sql query ?

Answer Question   |  February 6, 2009  7:18 AM
Search string, SQL, SQL Query

Creating a CSV file to FTP
I just loaded Office 2007 and created a csv file which then was FTP’ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

Answer Question   |  February 8, 2009  4:56 AM
Comma Separated Values, CSV, CSV format, Excel 2007, FTP, Microsoft Excel 2007, Microsoft Office 2007

Performance of very large SQL Server table with millions of rows
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it [...]

Answer Question   |  February 6, 2009  12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases

SQL Server Query Help Needed
I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I’m trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the Inventory Transaction table to the Shipment (Sales Order) tables [...]

Answer Question   |  February 6, 2009  10:39 PM
INNER JOIN, JOIN statement, LEFT JOIN, RIGHT JOIN, SQL, SQL queries, SQL Query, SQL Server development, SQL Server Query

Oracle vs Java programming
Which is better Oracle or Java? I have a interest in programming. What should I learn?

Answer Question   |  September 17, 2011  7:33 PM
IT career planning, IT careers, Java developers, Oracle development, Programming Careers

How Do I release unused space from a tablespace after dropping a blob table
I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles [...]

Answer Question   |  February 10, 2009  5:11 PM
BLOB, Oracle Tablespaces

Limit number of rows in a table
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]

Answer Question   |  February 6, 2009  7:26 AM
Auto increment, Database programming, SQL

Access 2007 Report OutputTo Print
Please help. This is driving me around the bend. I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see: Has anyone encountered this before? I have many other reports and they all save correctly with all calculations [...]

Answer Question   |  February 10, 2009  5:08 AM
Access 2007, Access 2007 printing, Microsoft Access 2007 Reports, OutputTo, Rich Text Format

To retrieve records from SQL Server database
Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named “Name” in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on…. Now, through some application [...]

Answer Question   |  February 10, 2009  3:35 AM
Query optimization, SQL, SQL Server development, SQL Server Query

MS Access – Create Median Aggregate Function
Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I’m using 2007)? In particular, I want to create “Group By” queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it doesn’t work as a [...]

Answer Question   |  October 27, 2009  5:30 PM
Access 2007, Access 2007 functions, Access Functions, Aggregate function, Median, Microsoft Access

Oracle archives are not moving from primary to standby database
Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

Answer Question   |  February 3, 2009  4:10 PM
Backup, Database Backup, Oracle Archives, Oracle backup, Standby Database

ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Answer Question   |  February 3, 2009  3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades

Single “Filler” Field Flat File vs Multiple Fields Defined Flat File
What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields? For example: Physical File: TESTFILE1 R TESTFILE FIELDA 50 Physical File: TESTFILE2 R TESTFILE DEFINED1 20 DEFINED2 10 DEFINED3 5 DEFINED4 15

Answer Question   |  February 4, 2009  3:20 PM
Flat files, Multiple Field Flat Files, Single Field Flat Files