• Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • How Do I assign a value if a value in the field is empty

    In my script (that is not working yet) I want to make sure if "full_value" (a field) is empty in a particular record then the value zero will be inserted. This is working in Access, but I'm trying to rebuild the query in SQL. Thank you. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1,...

    Ilfoprog50 pointsBadges:
  • auto transfer of as400 to pc

    Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help

    Nikolai196030 pointsBadges:
  • MS Access Forms

    I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form and...

    Gaildean5 pointsBadges:
  • I want to return multiple value in the THEN clause of CASE statement

    I want to return multiple value in the THEN clause of CASE statement. SELECT c.company_code, c.com_inactive_flag, e.emp_no FROM company c, employees e WHERE c.com_code = e.com_code AND e.emp_status in ( (CASE c.com_inactive_flag WHEN 'N' THEN 'A' WHEN 'Y' THEN 'B,C' END) If the flag is N all those...

    Balcode5 pointsBadges:
  • job problem

    i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', job_action...

    Abdo5 pointsBadges:
  • Convert table entry from text to numeric

    I have generated a table that has a 4 char text field. I want add a column and convert this text field that is numbers to numeric so that both coexist.

    LHammer5 pointsBadges:
  • database form

    I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go...

    Sturdy2725 pointsBadges:
  • Date Ranges in Access 2000

    How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?

    LVogel5 pointsBadges:
  • New to php/mySQL having an issue with Mac OSX

    I'm following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I'm checking to make sure it's all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying...

    Kjtriplett15 pointsBadges:
  • Which Is More Optimized

    Which Conditional Statemnt Is More Efficient in VB.NET 2005 IF ELSE OR Switch Case ?

    AnjanaDurga70 pointsBadges:
  • Highlight Keywords in Access 2003 Forms

    I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?

    Morgandtx5 pointsBadges:
  • how to find first record from group in crystal report with .net

    We have grouped according to our Accoutname field from databse. now we want to fetch only the first record from the group as we want one condition to be applied only on first record of the group and for rest another condition.this we want in every group not only one!!

    Erpdiamond5 pointsBadges:
  • Insert for a table

    I have a table which consists of lakhs of records and itemnumber is one of the column.I want to insert those records into the same table but with different new itemnumber from another table.what is the best way of doing it?

    Vishy5 pointsBadges:
  • ODSObject to Infocube

    TransactionData Loading from ODSobject to Infocube Manually from FlatFile

    ITSME15 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005

    Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

    ITHULK10 pointsBadges:
  • Trigger programs

    In a trigger program, is there a way to retrieve the program name that initiated the event?

    mcg15 pointsBadges:
  • Trouble configuring two Cisco 1310 for building-to-building Wi-Fi

    I tried to connect 2 Cisco 1310 for a building to building connection via Wi-Fi. I used the following sample configs found in this tip, called Configure Cisco wireless bridges for point-to-point networking. One the Cisco 1310 Access Points/Bridges starts up and the connection stays up for a few...

    NetworkingATE1,545 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following