• ordering dates in Oracle

    how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001.........like this. plz suggest some answer for this.

    Deb4u50 pointsBadges:
  • Need query to retrieve data from a given date in Oracle 10g

    i have some data to retrive from one table based upon certain condition.when ever i will query to retrive data [strong]it will return all the data based upon the date range.suppose i will enter 22-jul-2010 then the query should return from the year july-2010 to may be 2011 or 2021.upto the last...

    Deb4u50 pointsBadges:
  • Connecting databases in Oracle9i

    Can u tell me how to connect database files in oracle 9i software

    Varsha500950 pointsBadges:
  • Oracle Help?What is the DB dependencies related to object sequencing for DB builds

    What is the DB dependencies related to object sequencing for DB builds?

    SpockII5 pointsBadges:
  • How to connect to database inside VMWare from the web applications

    Hi All, I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this...

    Swatigaur25 pointsBadges:
  • Importing sound Class

    hi, My technical environment is: Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i. I created a sound.java file using Oracle9i JDeveloper, I compile it and the result is: " Compiling... D:Dev9ijdevWorkspaceWorkspace5soundsrcoracleformsfdSound.java Successful compilation: 0 errors, 0...

    FormsBuilderOracle10 pointsBadges:
  • Database auditing

    Hi everybody? I do have a shema named PRACTICE with its own table named EMPLOYEES. The table has fields: empid,fname,sex and age. Their data types are varchar2,varchar2,varchar2 and number respectively. The fields also held values LA,Lensa,F and 21 respectively. Being on the sys schema, I defined a...

    Girma30 pointsBadges:
  • Oracle 10g Database Housekeeping

    i've been asked to work on database housekeeping, i don't know what i should do? please advice

    DB10g15 pointsBadges:
  • SQL Server 2008 R2 provides direct integration with Oracle Database

    Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?

    ITKE345,020 pointsBadges:
  • How does profile limit for PASSWORD_REUSE_MAX works

    How does the profile limit for PASSWORD_REUSE_MAX works for Oracle Enterprise Database 9i ? Suppose we set PASSWORD_REUSE_MAX to 5 in a profile for a user. Now this user tries to change his password, then at that point how does Oracle engine checks if the new password the user is giving matches to...

    Maxmachine5 pointsBadges:
  • Problem in connection oracle lower version client with oracle database

    Problem in connection oracle lower version client with oracle database.

    Webtechsolutions55 pointsBadges:
  • multiple instances of an Oracle database

    how can i create multiple instances on one oracle database on my machine

    Bassgui5 pointsBadges:
  • high-values low-values (microfocus COBOL in Oracle/Linux environment)

    Successfully remediated 80+ programs from mainframe env to run in microfocus cobol against Oracle DB in Linux env. I have one pgm that is moving high and low values to output header trailer records per requirement. Leading 9 bytes of each record. My problem is that when it ran on the mainframe I...

    Zcr00245 pointsBadges:
  • What steps are involved when source DB is a Oracle and target db is SQL Db?

    How to test  when source DB is a Oracle and target db is SQL Db? What  to test  in particular when source DB is a Oracle and target db is SQL Db? I have worked on when both the target DB  and Source Db was SQL Server.How is it different when Source Db is ORacle and Target DB is SQL Server....

    Mayurkhe295 pointsBadges:
  • Oracle DB import/export

    hi everybody! I'm using oracle 10g db. I do have an oracle instance with user name aa and password aa. And also I do have another oracle instance with user name bb and password bb. I want to import a data base from aa into bb. I know that bb has to have accesses atleast what aa has. With these...

    Girma30 pointsBadges:
  • Updating a test database without disrupting production?

    We have an Oracle 9i (9.2.0.3) database and we need to update my test database many times a day. What is the best manner to update my test database without stopping my production database?

    ITKE345,020 pointsBadges:
  • Oracle database access problem over WAN

    We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure...

    Dobhalg10 pointsBadges:
  • Oracle Certification?

    Hi, I want to know, the total procedure for Oracle data base certification. Thanks

    Amin4rmOvexTechnology250 pointsBadges:
  • Calculating concurrent users based on active members in DB

    Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...

    MEUser5 pointsBadges:
  • get a anr record from databse by using max (one Field) and orderby (one filed) desc

    Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

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