• Calling an Oracle stored procedure in Java

    In my Oracle database, I have this stored procedure: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Here's what the IDS_TABLE means: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) Would it be possible for...

    ITKE366,150 pointsBadges:
  • Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Sameera5 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • How to access Exchange Server using PHP

    I've been writing a CMS application in PHP and one of my requirements is that it must be able to interface with my customer's Exchange Server. I've wrote something similar for this before and used WebDAV but now I'm leaning against it. The site will be running on IIS or Apache on Windows Server...

    ITKE366,150 pointsBadges:
  • How to get print on any HP printer from DOS mode Foxpro software?

    I have prepared software in DOS mode (Foxpro 2.5) and doing well with Dot matrix printers but now the demand for Deskjet print out has increased and I am unable to provide the same as the commands from DOS mode. It's not supported to print on Deskjet printers... Anybody know the solution? Can...

    Srmsoft5 pointsBadges:
  • Web Scrapping in VBA

    How to use getelementsbyclassname and getelementsbyid in web scrapping by VBA?

    shivu639815 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE366,150 pointsBadges:
  • SHA1 Digest in Perl.

    Is SHA1.pm ( Perl module for SHA1 algorithm ) included in the perl download package from web? I ported a script from a Linux environment to an AIX environment. This script uses the SHA1 message digest. Although, perl exists on the AIX environment ( checked this using perl -v) , the script can't...

    Sudhiriyer10 pointsBadges:
  • MySQL CrossTab Query

    MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

    Carbon0 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:
  • SQL MS Access – Displaying output in a certain order

    Hi Team, SELECT mergeddatabase.Roomno, Count(*) AS Boxesscanned, Sum(mergeddatabase.Currentweight) AS RoomsTotalweight, mergeddatabase.Currentdate AS RequestedDate FROM mergeddatabase WHERE (((mergeddatabase.Currentdate) Between [Forms]![FrmDateRange]![TxtStartDate] And...

    Witsend10 pointsBadges:
  • What is SHA1

    What is SHA1?

    sirpelu5 pointsBadges:
  • Bare minimum templates for Project Management

    20 projects, 80 teams members, are engaged. for project management what will be the bare minimum templates required for best control of the projects. teams are scattered at various locations. can someone list the name of the templates required (for complete project management, and covering the...

    Jaideep Khanduja10,075 pointsBadges:
  • COMMUNITY ANNOUNCEMENT: Tell us your Data Center Tales and you could win a Nintendo Wii

    Tell us your Data Center Tales and you could win a Nintendo Wii We want to hear your stories or see pictures of your craziest data centers. Your contest submissions will be published on the Tales from the Data Center blog for all to read. This two-month long contest (Oct-Nov) is your chance to win...

    ITKE366,150 pointsBadges:
  • Dynamically call a javascript function.

    Lets see if I can explain it. I have an INPUT html element, and I has stored some value on it. This value is a javascript function name like this: <input id="myinput" value="doSomething();" type="hidden"> In a javascript function I'm getting the variable this way: var aFunction =...

    Mariodlg2,790 pointsBadges:
  • How to use XML in RPG

    Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the complete process or code. Thanks.

    RPGPGM40 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