• Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl69,045 pointsBadges:
  • log sql queries?

    queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

    Ktpierce5 pointsBadges:
  • Oracle 6i How to Save the Value of a Parameter so that next time when report runs it uses the last given Value

    Dear All Hope that you all will be at the best of your health and job,,,,, I have made a report in Oracle 6i. and given the options to user so that he can show/Hide a colum on report at run time... by passing a parameter with values Show and Hide..... if the user makes a colum Hide then that column...

    Cutejut10 pointsBadges:
  • Label in oracle

    I have heard of local labels in oracle, do we have something called public labels?

    Nilesh197910 pointsBadges:
  • HOW TO SAVE DATA FAST

    I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad's save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case...

    VEERRELIANCE10 pointsBadges:
  • Variation in space occupied in same TABLSPACE by equally populated tables.

    I am inserting data in table T2 from T1(INSERT INTO T2..SELECT..FROM T1..). Both tables are in same tablespace. Even though records in T2 are less than T1,size occupied by T2(12 GB) is much higher than T1(440 MB). WHat may be the reason(s)?

    DBDEV5 pointsBadges:
  • Oracle 6i runtime installation

    what is runtime installation

    Idram5 pointsBadges:
  • Can I install Developer 6i and make/run forms and reports on Windows Vista?

    I am going to change my windows xp to vista, I want to know if I can form/report developer 6i on it and build my forms or reports? Does it make any problem? Thanks.

    Heidari102435 pointsBadges:
  • rdbms and dbms

    what is rdbms and dbms in oracle?

    Gkg5 pointsBadges:
  • Need help with this Oracle Query

    BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009 10:08:57 60 006 0 20090045 5 01/14/2009...

    FidanSheza10 pointsBadges:
  • I need Run oracle applicationfrom host browser

    I installed oracle application R12 on vmware linux red hat 4 from windows xp operating system , How Can I run oracle application from windows browser?

    Lahham5 pointsBadges:
  • Please help . What I am doing wrong

    Dim cmd As OracleCommand Dim ds As DataSet Dim dv As DataView Dim da As OracleDataAdapter = New OracleDataAdapter ' This does not work.. which is what I need, Country and State are entered by the user - cmd = New OracleCommand("Select state_code, state_name, state_status" & _ " FROM m_state" & _ "...

    Dax70 pointsBadges:
  • Online Question and answers on Oracle or any other language

    Is there any site which provide the facility in which we can ask questions about the oracle and at a time we get the answer. If we have dabase related question then also we get the answer is there site and if yes then reply....

    Digvijaysinh10 pointsBadges:
  • Which kind of features we can add in the Traininig Management System

    Hii alll Can anybody tell me which kind of features i can add in to the Training Mangement System Project as i am developing it. I am developing it into oracle Apex. If any body have any idea then send as sooon as possible as i have to submit it soon.

    Digvijaysinh10 pointsBadges:
  • Regarding PeopleSoft HCM installation

    I was trying to install a demo Peoplesoft 9.0 HCM application with Peopletools 8.49. After the installation I encountered a small error. The web portal is working fine but while going for Peopletools login it is NOT showing the connection type as Oracle instead showing Application server. I went...

    Creativelinks20 pointsBadges:
  • Web based forms and Oracle databases

    I am researching software that designs/builds web based forms for data input and output that will work with Oracle. I am looking for suggestions on the newest most efficient software available for designing, creating and managing webforms that comunicate to an Oracle database

    BCTS5 pointsBadges:
  • Oracle tutorials at work, does it need licenses?

    I got a Trainee-position with a large oraganisation and have started to understand that trainee in this case is going to mean "training myself". I'd like to do some Oracle tutorials, for this I would need a local installation of some Oracle software - im not even alowed to install Mozilla on my own...

    Janetsson15 pointsBadges:
  • How to connect Oracle 9i to Visual Basic by ODBC?

    how to connect oracle9i to vb6 by odbc? plese provide me code also?

    Rk90405 pointsBadges:
  • OEM for Oracle IAS 9.0.4.1 not running

    When I use the url http://localhost:7778 I get the IE cannot display the webpage. i also get the same error when using the url http://<my pc name>:7778 I've tried 7777 and 7779 as well with no luck. Please help!

    Ma110 pointsBadges:
  • How to publish oracle application server with isa 2004

    Dear sir, We have isa server 2004 with 2 nics one connected to our lan and the second is connected to the router we want to ad a new oracle app server to our lan and be able to access this server from outside pls explain in details how to do that. thanks a lot

    Agalal5 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