[oracle] Forum Topics

Sir i am B.SC., graudate i have one doubt that is how connect oracle database and vb please clear this problem sir.

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 …

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 ?!

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 …

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 …

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, …

Hi, I want to create a button which, when pressed, calls a procedure passing certain parameters to it. How do i do this? htp.formsubmit...? Thanks

i'm having trouble figuring this out b/c i have the version of oracle that doesnt support ora_numcols, etc... anyways, here is my query... $query = "SELECT DISTINCT S.FName, S.MName, S.LName, S.Address1, F.Value, F.Feature_id, S.zip, S.Student_id FROM Student S, AwardedScholarship P, stu_feature F WHERE P.Is_Pending = 'Y' AND F.Feature_id in (" …

I want to write a PL/SQL Stored Procedure. A Project is created in database. Please help me in applying the following logic in stored procedure. " Project start date and end date are stored in project_date table. Whenever the project start date and end date are amended from oracle forms …

Good Morning Friends, Could you please tell me how to send mail to more than one recepients along with attachment? I know we have to use UTL_SMTP package for this, i need full snippet. Many thanks

Please help me about knowing what is semaphores in oracle as well as what is the use of DBMS_ALERT package in oracle 8i or later...with some nice examples. Many Thanks, Shahnaz

i want to know abt the ddl stmts.

Hi, I have to build up an web application (ASP.NET) that communicate with its own Oracle database. Also this application should write some data (like inovices, payments) into Oracle Applications 11i database. Do someone knows how could I implement these features? Is there any Oracle API that I can use …

How would you display in your sql a column of brackets [ ] with a field width of five spaces in between?

i try to make a select table with condition now such as; <? ... $res = $conn->Execute("SELECT ID_SKENARIO,DATE_I FROM T_SCENARIO WHERE DATE_I = NOW"); While(!$res ->EOF) { echo $res->fields[0]; } ... ?> what is the right synta for condition date is now ? please help me... :sad:

i am interested in knowing how to make my resultset updatable. i am currently running jdk5.0 so it should already acquire such information, but the following code is throwing me errors. public String execute( String newPassword ) throws ClassNotFoundException { //private variables Connection conn = null; Statement stmt = null; …

Could anyone tell me: The different of development effort spend to develop the web-based application on Oracle RDBMS and Oracle XML DB. Is it difficult to develop something on Oracle XML DB? The functions are normal maintenance operations such as add, delete... Moreover, how about the SECURITY function? How to …

How to convert Tamino XML DB Server to Oracle XML DB Server and/or Oracle RDBMS DB Server? I got 240GB data stored in Tamino XML DB server. My clients request to convert them into Oracle. Since I am not familiar with Oracle XML DB Server (latest and stable version is …

Hi, Below is code to gather information from a beg and end date but hwo would I generate information on each day of the week. Sunday - Saturday for a set of specific date ranges? [code] Select Count(b.max) From lm.dw a, lm.bw b Where (a.Start_dt <= getdate() and a.End_dt >= …

Can anyone suggest a good beginner book for learning Oracle and SQL that they have used or know someone who has ? sabd

Hello guys, I have [COLOR=DarkSlateBlue]Oracle9i[/COLOR] installed in my homepc and my O.S. is [COLOR=Navy]Windowsxp-professional[/COLOR]. Now,I want to connect Vb using [COLOR=Indigo]Microsoft OLE DB Provier for oracle[/COLOR]. For this i have done the following steps--- 1. Created a text document and renamed it with extension .udl 2. On openning the file …

hi friends, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many …

Hi friends Can someone help me in this pls.I have 2 tables in my DW One is a table which have all data regarding Income and Expenditure details. The structure (columns) of the table is ctgry_id,ctgry_nm,sbctgry1_nm,sbctgry2_nm,amount.,cmpny_id and tm_id So the records in this table would look like 10001 Wages and …

hi friends, i/m not that experienced in ORACLE. ..and i am not in to that domain. but a neede arise. i want to read bulk data (we cant predict the format of data) coming from a network connection into ORACLE-8i server. how i code this requirment? please help me giving …

I have linked via odbc from within MS Access 2003 to a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and size of 21. When I view the table in access the numbers appear like …