Hi forum,
I'm trying to force oracle to use the sort merge using hints.
Can anyone suggest why the below code is working correctly?
Please see the explain plan.
Regards, Chris.
set autotrace on
timing start
select /*+ use_merge(e) */ e.fk, d.fk
FROM girl d, boy e
WHERE e.fk = d.fk;
timing...
Hi Forum,
I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons.
However when the recipient receives the mail the buttons are blocked or...
Hi Forum,
I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons.
However when the recipient receives the mail the buttons are blocked or...
Hi Forum,
I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons.
However when the recipient receives the mail the buttons are blocked or...
I have a html page which contains the header for my web site (graphic, buttons etc)
I would like to include this banner html document at the top of all the other pages within my web site.
Can anyone help me achieve this?
I thought it would be something like
<include 'banner.html'>
But this...
Hi I'm just starting to learn mysql for the first time.
I know in Oracle SQL*Plus you add comments to your code using the REM statement.
How can you add comments in mysql?
Cheers,
Chris.
Hi.
I'm new to php and trying to create a shopping basket for the first time.
Firstly I am trying to create a php script to display the items in my sql database on screen before I move onto creating the actual on-line basket.
The script below display's the items as I wish however it produces...
Hello.
I have a vb program that creates several reports by opening an excel file inserting the contence of a database and then sorting as required using an excel macro.
There are three difference macro's depending on the report required.
The program works if I only generate 1 report however...
Hello.
I have been puzzelled by this for several days now... so any help would be much appreciated.
I have an excel spreadsheet with data in that I wish to sort. However the top row contains the headings for the cells.
I would like to be able to select all the cells with data on the sheet...
Can anyone tell me why when I run the code below, I get an error message 'compiler Error, user-defined type not defined'?
The program exports the contence of text boxes on a form to a MS Word document placing them using bookmarks.
I got the adapted code from an earlier post.
Many Thanks...
I am working on a program that uses information from an access table to produce a report in word, using a visual basic enviroment.
However I am struggling with regard to inserting bookmarks into word using visual basic to place data in word document.
Using the code below i am able to create...
I have a form with a data control linked to a Access D.B. This allows users to create/update/delete the DB.
From this form I have created a Data Enviroment that generates a data Report.
The data report produces the report fine, If add/update/delete a record once and then re-run the report, it...
Hello.
I have a form with two text boxes on it.
These are linked using a data control to a access db.
I am creating a report of the items in the db using VB 6 built in report facility.
I have created a button to allow users to enter new items into the db using the text boxes that are bound...
Hi,
I'm new to all this.
I have been reading hybrid topology.
Is it possible to link a bus network to star network using a hub, or do need a switch?
Obvously the connections into the hub for the star newtwork will be RJ45, The cable for the bus network will be 10 base2 which will not connect...
Hello,
I am trying to create my first Pascal Program.
The program is suposed to read in the contence of 2 arrays;
- 1 has the student anwsers to a multi choice exam paper
- other has a specimin anwser.
I am trying to create a program that marks the papers, (there is only 1 correct anwser) and...
Hi,
I recently upgraded to xp pro from xp home.
Before I upgraded i had the ability under the power management options to put my laptop into stand by.
However all the power management options under display relating to going into stand by are now blanked out.
I have a Hi-Grade Ultinote M6500...
Hello,
I am trying to practice my skills as i am a beginner.
I have wrote the following program below to double a number.
I am now trying to create a while loop with a sentinel value.
When the user types eof, i am trying to get the program to stop prompting to enter a number and instead...
I have the following very simple program, shown below.
I am a newbe to HTML.
I am trying change the below so after the user has entered anything into the command prompt & pressed enter. It automatically refreshes the page with an command prompt.
Any help would be much appreciated.
Chris...
Hi,
I have sucessful finally linked my SQL database to dreamweaver. I now want to search the contence of a form text box in database.
I can find very little information on creating dynamic sites in dreamweaver. Could anyone point me in the direction of some relevent information?
Many Thanks...
I am trying to create some aspvb script pages that will connect to oracle 9i personal edition using windows xp and iis.
I can test a connection locally using the following connection string:
"Provider=OraOLEDB.Oracle.1;Password=tige;Persist Security Info=True;User ID=scott;"
But...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.