2,627 Topics
![]() | |
USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and … | |
Hi, i have an application that will save the xml to a large object cloumn in DB. It works fine if my xml are in ANSI but if UTF-8, it throws error. Any idea what is going on? Thankx | |
Sir i am B.SC., graudate i have one doubt that is how connect oracle database and vb please clear this problem sir. | |
Hi Guys And Gals I Am Basically A C,c++ Programmer And By Interest Learned ..net Framework,vb,oracle,my Sql,php,ajax,apache,html,xmland Script Side Languages Along With Perl And Cgi. I Quite Known Microsft Sql Server And Earned Diploma In Testing And Quality Management. Presently Studying Final Year B.e My Correct Project Is In Ajax … | |
I'm a novice at VB and wish to populate a datagrid by connecting to oracle table. I've an ADODC data control inwhich I've used Connection String and given the SQL query after selecting cmdText option. The test connection also succeds but only empty datagrid is displayed when I run the … | |
i have a data file in text format , i want to convert this text file again in to oracle data base file for this i want coding in vb such that to calculte from this byte to that byte should be update in particular field etc. pls help me? | |
Hi everyone, Just looking some advice and general tips, have a few questions about a final year project I am thinking of doing. Basically it is going to be a stock control system for a nightclub, particulary focussing on their celler. The system will allow the staff/management to review stock … | |
Hi everyone, Just looking some advice and general tips, have a few questions about a final year project I am thinking of doing. Basically it is going to be a stock control system for a nightclub, particulary focussing on their celler. The system will allow the staff/management to review stock … | |
Hello everyone, I am a beginner to shell script . I had to modify the following script and i get the following errors : sag.sh[11]: SAG: not found mv: cannot create /sag_0609131449.txt :Permission denied #!/bin/ksh LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/export/home/oracle/app/oracle/product/8.1.7/lib export LD_LIBRARY_PATH export ORACLE_HOME=/export/home/oracle/app/oracle/product/8.1.7 export STOCK=/export/home/oracle/app/oracle/product/8.1.7/bin export ENT=/home/atw11w99/ent/uc5 #SAG =$SAG:/home/atw11w99/ent/uc5/sag SAG =/home/atw11w99/ent/uc5/sag export SAG … | |
i just passed all my oracle exams using certmagic.com guides . they were right on money and had questions which were very close to real exams . Highly recommended . now iam off to start working on cisco track | |
i am learning on purhcasing hotcerts.com $85 package for my ocp exams . anyone knows how good are ocp exams of hotcerts ? . please do let me know. | |
hi people, I am very much interested to Oracle. I decided to write one exam soon and I am refering guides from certmagic.com. It seems good. Any of you know any good books than this ?! | |
Hi Everyone: Dani Horowitz was kind enough to let me post a job opportunity here in your forum. I work with a National Direct Placement and Contract Staffing firm near Portland, Maine - MOUNTAIN LTD. I'm currently working on a search for a Sr. Developer for a wireless company in … | |
Has anyone used the tools for this before? How does it handle the code differences, e.g. no SYSDATE in MySQL. Does it automatically change the differences. Thanks | |
Has anyone done this before? How does it handle the small code differences, eg... no SYSDATE. Does the migration tool actually edit your code? Thanks | |
Hello My webapp need to use Cyrillic and Latin ( "normal" character code ), could you tell me how to set nls_lang in my database and in the session.I tryied write string in hibernte , but when i tryied to read this string, this is only character '?', this column … | |
I am not a citizen, national, or resident of, and am not under control of, the government of Cuba, Iran, Sudan, Iraq, Libya, North Korea, Syria, nor any country to which the United States has prohibited export. I will not download or otherwise export or re-export the Software, directly or … | |
History of what is trying to be accomplished: Currently where I work, we receive a large number of excel documents which are used to manually change pl/sql scripts for updating oracle database's. From my research, I have found that oracle can not read excel documents, least not till 9.0, and … ![]() | |
Below is a working program that goes through the xml document and outputs all of the data to an output file. That part is fine, but what I need help with is that the tagname Comments: in the xml document will have the word Patch* in it. I need to … | |
Hi How to see the diffrence in terms of resources or response time between ALL_ROWS and FIRST_ROWS hints? Can we track the diffrence anywhere? Thanks | |
Hi I need to send a mail with text attachment from my PL/SQL procedure.I am using version 8i and tried with SMTP. I am able to send text mails but not attachments. Can any one help me!! it'l be great if you can share sample programs. Thanks HK:?: | |
Hi All, I am having a problem in writing a stored procedure. I have a table called as model year which has two fields model year and model status. model year is the primary key column. If the user inputs a model year, the stored procedure should check whether the … | |
I have apparently clicked something I shouldn't have and despite my best efforts cannot get this spyware off of my PC. I have gotten most of it off with ewido/adaware/windows defender, but [U]something[/U] is still persisting which doesn't show up in a regular session or a safe mode session. I … | |
Sir, I want to make connectivity in c with database oracle so plz tell me the code for that.thanx in advance. | |
Please how do I find out where the folders are that are serving localhost on my home pc ? I am running windows XP Home edition and I got localhost running after either the installation of ms SQL or Oracle 10g. Their is no problem running apps from it, all … | |
Since I became a Sun Certified Java Programmer (conducted by Sun Microsystems) on January 11, 2001, I have been involved in web-based programming and development. Before that I had 4 years experience in windows programming. In the last three years working in one of the world top companies, I was … | |
Hi All, I'm trying to call a parameterized stored procedure in C# using microsoft ODBC .NET. Could you please give me some help or hint? Thank you very much! C# code: ... //connection code odbcCommand.CommandType = CommandType.StoredProcedure; odbcCommand.CommandText = "BEGIN myProc(?, ?); END;"; odbcCommand.CommandTimeout = 0; OdbcParameter paramA = odbcCommand.Parameters.Add("@A_CNT", … | |
Hi, I have recently graduated and now a days looking for job. I am very confused about the platform. At which platform should i go. .NEt or Java ... for me both are having good scope, but specially in my country .NET is ruling ... there are almost 7 jobs … | |
hi, i am a user of Toad for Oracle 8.6.1 i am having a problem contructing this query [COLOR=#0000f0]SELECT [/COLOR]FAC[COLOR=#0000f0].[/COLOR]FACILITY_ABBR hall_abbr[COLOR=#0000f0], [/COLOR]COUNT[COLOR=#0000f0]([/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]ACCEPTS_MALES_FLAG[COLOR=#0000f0])[/COLOR] MISDEMEANOR_MALE[COLOR=#0000f0], [/COLOR]COUNT[COLOR=#0000f0]([/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]ACCEPTS_FEMALES_FLAG[COLOR=#0000f0])[/COLOR] MISDEMEANOR_FEMALES [COLOR=#0000f0]FROM [/COLOR][COLOR=#808000]HALL_UNITS[/COLOR] HALLUNIT[COLOR=#0000f0], [/COLOR][COLOR=#808000]FACILITIES[/COLOR] FAC [COLOR=#0000f0]WHERE [/COLOR]HALLUNIT[COLOR=#0000f0].[/COLOR]HALL_ID [COLOR=#0000f0]=[/COLOR] FAC[COLOR=#0000f0].ID AND[/COLOR][COLOR=#000000] HALLUNIT[/COLOR][COLOR=#0000f0].[/COLOR][COLOR=#000000]ACCEPTS_MALES_FLAG [/COLOR][COLOR=#0000f0]=[/COLOR][COLOR=#ff0000]'T'[/COLOR] [COLOR=#0000f0]AND[/COLOR][COLOR=#000000] HALLUNIT[/COLOR][COLOR=#0000f0].[/COLOR][COLOR=#000000]ACCEPTS_FEMALES_FLAG [/COLOR][COLOR=#0000f0]=[/COLOR][COLOR=#ff0000]'T'[/COLOR][COLOR=#0000f0]GROUP[/COLOR][COLOR=#0000f0]BY [/COLOR]FAC[COLOR=#0000f0].[/COLOR]FACILITY_ABBR the result is: hall_abbr MISDEMEANOR_MALE MISDEMEANOR_FEMALES BJNJH 1 1 … | |
I am having running the getProxy function from my server machine at work. I tried using the same code below from my server at home and it worked fine with no problems. Is there a setup option of some kind that I may be missing? // Define needed parameters and … | |
[B]Hi Everybody, i am working on C++ and Oracle both but now i want to connect them,i want to retreive data fron SCOTT database of oracle using C++....i have no idea about it please help me....how to write a program,what steps to follow..[/B] [B]Priya[/B] | |
Hi everyone I am really having trouble right now with oracle for linux. Please tell me how to connect oracle using c/c++ in linux. If anyone knows about any tutorial or have code, please plzzz post me that as well. | |
THE ERROR MESSAGE WAS: cannot delete oci.dll:Access is denied Make sure the disk is not full or write-protected and that the file is not currently in use. somebody help please | |
can u kindly check what am i doing wrong? i tried using oci8 and the image is displayed but when i use adodb, my browser(firefox) says "problem loading..." can you give me some example of your code? thanks! [B]OCI8[/B] [I]<?php header("content-type: image/JPEG"); $getId = $_GET['id']; $User = "scott"; $Password = … | |
Hi, can anyone hel me how to connect to database in struts? I am using Oracle DB of personal pc. Tomcat 5.0 and struts 1.2.9 thanks lalit | |
hello friends .i am troubled in to carry the tables in one computer to another computer. i want information about that: i did the project in VB with back end Oracle. i want to carry tables to another system. i dont know how to carry the tables to another system … | |
When submitting a page via the internet, I get a 500 error and the location of a file in jsp. Are you able to help?? Basically I have an expense system implemented with JSP in JBuilder 4 using Oracle 9i and SQL Plus. When submitting any pages in the system, … | |
I have just started to learn VB.i'm making a database using oracle and vb6. i have a listbox of items and a search button. one can see the details of a particular item in the listbox in a couple of textboxes in that same form by clicking on the search … | |
Hi everyone, I hope you are all doing well :) Ok, questions... I finally found a new hosting company that I want to sign up with & now there seems to be problems with them understanding what I need. On my current hosting company I can store my manuals & … | |
Hello, I am getting this message in the taskbar every now and then... [URL="http://img126.imageshack.us/my.php?image=virus5nu.jpg"][IMG]http://img126.imageshack.us/img126/955/virus5nu.th.jpg[/IMG][/URL] Please help me to get rid of it.. I did a HighJackThis scan as mentioned in some other topic.. But dont know how to proceed.. Please help.. Here is the hjt log... Logfile of HijackThis v1.99.1 … | |
some easy questions about c++ 1. is it possible to link the c++ files with databases like oracle,MySql? (coding the file to access the databases) 2. can we put the compiled files on websites? Google.com is build in C and C++ and their search engine is running on that. how … ![]() | |
I would like to know if anyone has bench marked MySQL server, compared to Oracle. I have developed a database that will sort 1,000,000 records in less then 22 seconds (100 byte record sorting on 2 fields, and 1.3Ghz cpu). | |
hello for all i have a project in my faculty to connect oracle and sql server and access with java and i do all but i can not connect java and access how can i do i ? | |
Hi All!, I have a small query editer with a textarea and a buton.The user gives their query in the textarea and click the button it will returns the data to a datagrid.The use gives [B]SELECT[/B] query then the [B]data grid[/B] will give the data.suppose user gives [B]update or delete … | |
Hello Everybody! I Joined this forum yesterday.. Name : Hemant K Education: B.Sc., DCA Occupation: Service as Systems Manager in FMCG Company Area of Work : Software Development, ERP, Web development, Oracle, D2k, Abap etc.. Location : India Hobbies: Reading, Writting, Singing, Music, Making friends Hemant K :) ![]() | |
Hi Every body I want to know how it is possible to connect to database whether it may be Oracle,Ms-Access.I am using Turboc2 Compiler and windows OS and i found something like ProC that is file extension as .pc in Oracle 9i is there any relation between these i want … | |
Good morning! I hope someone can help me with this. My sister sent me an AOL AIM virus and in my attempts to google a fix for it I think I made the problem worse! I believe it also installed Surf Sidekick and Web Nexus - I think I made … | |
i have to design a login form for my project with loginid and password.:sad: [B][U]Problems[/U][/B] 1) i have to store passwords in encrypted form 2) connectivity of asp.net with oracle 8i after cross checking of password and loginid next page should display details account so please help me on this:?: … | |
I've been in and out of Linux for a while know, that last installation I used was SuSe, not happy.... the bast I've used was Red Hat 9. I need something to work with Apache and MySQL AND Oracle... of course, it has to be free. I tried this choose … ![]() | |
[COLOR=#555555]Hi everybody, this is me Shemayell a new member in your community, I just join today ..[/COLOR] [COLOR=#555555] [/COLOR] [COLOR=#555555]Im an Arab female from Middle East .. UAE, [/COLOR][COLOR=#555555]i used to work as a Computer Programmer, i worked with Oracle[/COLOR] [COLOR=#555555]i like computers the most and i spend most of … |
The End.