1,488 Topics

Member Avatar for
Member Avatar for agrawaltanu1

Hi I am working on Oracle database 10g. I am trying to implement advanced replication on my database. Till now I have replicated tables and those are working fine. Now I want to replicate procedure, in this case on running all the procedures(adding packages and generating replication support) I am …

0
59
Member Avatar for mahul000

String serverName = ? String portNumber = ? String sid = ? Plz answer my above queries , while conecting with oracle 9i and Java.... its urgent !!!

Member Avatar for jwenting
0
147
Member Avatar for haria_kishore

Hi everyone I have one master table with the following structure incm_id Category SubCategory 1001 Expenses A 1002 Expenses B 1003 Income C 1004 Income D I have a child table where i am capturing amount value for the above table and structure is something like id fk_incm_id Amount 10001 …

Member Avatar for alit2002
0
124
Member Avatar for msimonds

I was wondering if maybe someone could shed a light on something for me. I am performing the same SELECT Statement from Oracle on two servers via a simple export script. [B]Server one:[/B] My Localhost Apache/2.2.0 (Win32) PHP/5.1.2 from a RAW field and it is returning the ascii characters, which …

0
103
Member Avatar for tech291083

hi, i am looking for a free download by oracle meant specifically for linux. i am using fedora core 5 32 bit version of linux. thanks.

Member Avatar for tech291083
0
76
Member Avatar for seibor

hey all pls suggest me how to start creating database and tables in oracle.

Member Avatar for alit2002
0
93
Member Avatar for vandora

Hi I have a test vserver and a production server both running linux. Currently a database has been created on the test server and is used for testing applications. Now the databse is ready to be transferred to the production database. And it should function in the exact same way. …

Member Avatar for alit2002
0
97
Member Avatar for butterflyTee

i have tried to answer this question like this (show your attempt) and i did it like this because (show your reasons why you think it is the correct approach) and the results that it gave are like this (show the results that your query produces) and i cannot understand …

Member Avatar for alit2002
0
1K
Member Avatar for Amelia_25

[COLOR=#000000]I am already in job and have very little time for myself. I can spare two hours daily for [/COLOR][COLOR=#000000]preparation. For which certification should I go now? My current work is database management so i'm thinking of oracle certification, guide me in this way. Please suggest some resource too. [/COLOR]

Member Avatar for tech291083
0
57
Member Avatar for raj.sagit

hi im new to jsp i have to connect oracle database 8i with jsp page i want step by step tp connect into oracle database i already refered many threads in this blog as im new to jsp i cant get exact procedure can any 1 give me step by …

Member Avatar for skandar
0
94
Member Avatar for nihilks

i use ADO in VB6 to connect to my Oracle database i made a connection object 'con' and opened the database using it when i executed the statement con.Execute "insert into employee(no,join_date) values(424,'12-SEP-2004')" i found that he new record was inserted into the database(i checked it using sql*plus) . But …

Member Avatar for nihilks
0
209
Member Avatar for aspiring_oca

Hi everyone, I have a little work experience with Oracle. But am a little apprehensive about giving the OCA exams.:confused: Could anyone who has already cleared these exams guide me regarding - 1. which books to refer for both these exams ? 2. how exactly to prepare for these exams …

0
71
Member Avatar for butterflyTee

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 …

0
69
Member Avatar for amateur83

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

0
65
Member Avatar for manimegalai

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

0
47
Member Avatar for sameer1982

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 …

0
90
Member Avatar for jazzlall

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 …

0
48
Member Avatar for john_pro

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

0
57
Member Avatar for smith_demon

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.

0
58
Member Avatar for developer_me

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

0
50
Member Avatar for castro1688

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

0
84
Member Avatar for castro1688

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

0
79
Member Avatar for kloc

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 …

0
54
Member Avatar for ! !

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 …

Member Avatar for feroz_kh
0
104
Member Avatar for hari_bk

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

Member Avatar for jim mcnamara
0
69
Member Avatar for hari_bk

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

Member Avatar for jim mcnamara
0
68
Member Avatar for Jayashaki

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 …

0
116
Member Avatar for emeraldth

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

0
53
Member Avatar for priya_2006g

[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]

Member Avatar for priya_2006g
0
244
Member Avatar for deadprogrammer

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.

Member Avatar for WolfPack
0
163

The End.