• Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to Oracle side, so I know the concept of SQL and PL/SQL. Relating to this I dont have a project of this. So please give me some titles of project at least I can go through this. Regards.

    Ingalagi5 pointsBadges:
  • Export data from Forms to Excel

    How to export the selected data from Forms to Excel?

    Brithivi5 pointsBadges:
  • Selecting multiple members at a time in SQL

    I have customer file (CUSFILE),this file having 3 members (JAN, FEB, MAR). Using ALIAS,I can select only one member. CREATE ALIAS CUSMBR1 FOR CUSFILE(JAN). SELECT *FROM CUSMBR1. How to select multiple members at a time in SQL. Please help me.

    chowas400260 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • Displaying SQL data in ASP.NET

    I've put data in a description field in SQL; how can I display it in ASP.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Free SQL software with interface to enter data

    Hi, I need to enter about 5000 lines of data with about 10 columns. and then I would query the data (by lets say SQL, but I'm open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view only that data...

    Maqib1005 pointsBadges:
  • Sql Server 2005 ensure columns sum within a table

    How can I ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

    Timmytong5 pointsBadges:
  • AS/400 compare files

    I want to compare two files without using SQL and logical file. I have written a code but I didn't get exact out put. Please look into the below code and help me guys. File:test1 Keyfield=accid ACCID   ACCNAME 1   siva 2   hari 3   vinayaka File:test2 no key field here ACCID   ACCNAME...

    chowas400260 pointsBadges:
  • Project on class diagram plotter using Java and SQL

    Hello Sir / Madam, I got project on class diagram plotter. I need proper guidance on this topic because I need to submit synopsi .

    Shal235 pointsBadges:
  • Convert time to GMT time

    In T-SQL, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    I want to make the SQL connection with VB 6. How do I open the connection in SQL?

    Vishalngp15 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • The difference between YYYY and RRRR in Oracle SQL

    My partner and I have two different queries in Oracle SQL. Here they are: select trunc(to_date('27-Jul-1987'),'YYYY') FROM dual; And select trunc(to_date('27-Jul-1987'),'RRRR') FROM dual; But both queries are giving us the same result. What's the difference between YYYY and RRRR? We appreciate any...

    ITKE351,300 pointsBadges:
  • Can you force a user input in a SQL statement, then have the statement continue running

    Hi, can one in an SQL statement, when running in SQL, force a user input to be entered and when entered? The SQL continues to complete.

    Bugsy5 pointsBadges:
  • Get all the numbers between two numbers in Oracle SQL

    Does anyone know of a way to select the numbers (or integers) that are included between two numbers with SQL in Oracle? I can't create a PL/SQL procedure for this. Here's an example: I need to get the numbers that are between 3 and 10. Obviously, the results would be 3,4,5,6,7,8,9,10. How can I do...

    ITKE351,300 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • insert date only into SQL table

    The getdate() function returns the date and time. How can I just get the date?

    Gina35 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Sum using SQL

    What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

    mohammedwagihe5 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