2,627 Topics
 | |
| | I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates … |
| | Hello everybody My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table. I have some datasources that come in files periodically. I'd like to limit the days stored for each … |
 | Hello Experts, I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only. I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql. The replace() … |
| | [I] Name: [/I] The name of this question is bundled_resources [ICODE] Hello and Thank you in advance for any assistance. [/ICODE] [U] [B] Purpose: [/B] [/U] [B] The purpose of this code is to change the label of a commandButton by hijacking the resource bundle functionality and setting the label … |
| | [code] [/code] Hello I have a couple classes here and a resource bundles and a JSF that sends the key to the class (MessageProvider) and MessageManager.java gets the resource for the selectOneMenu component label. I would like to change the label on the submit button depending on the choice from … |
| | hello all.. im a newbie..in both complex database design and oracle pl/sql ,and im very unsure/confused about the structure of my tables and how to normalize some info. ok so heres the situation. i have a company,employees are distributed according to dept and section and category.each category has number of … |
| | Hello, I am somewhat of a SQL newbie. My question is how would I go about creating a query that searched for things like: 1. users who have collected a complete set of promo items 2. users who have purchased every movie from actor X 3. users who have purchased …  |
| | hi, what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply. <URL SNIPPED> |
| | I want to find duplicate names from my database I wrote the following query. But it is displaying more that existing records. I guess it is taking cartesian product. select a.name from emp from emp a,emp b where a.name=b.name; can anyone correct this query. I want to display all the … |
| | Hello folks, I am trying to run a simple java application which connects to Oracle 9i and gets and displays the resultset. I am connecting to oracle using sun.jdbc.odbc.jdbcodbc bridge driver. [B]**The application was running fine 4 days ago**[/B]. I m using Netbeans 6.0. Two days ago I installed Netbeans … |
| | hi i am looking for a jiob as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time … |
| | Hello everyone I need a solution for my problem. The solution can be a simple PL/SQL block or a trigger I have a table called T_SBSTTN_VLTG_MSTR with following data SBSTTN_CD VLTG STTS DT_ENTRY FK_TM_ID 10111111 11 Existing 2/9/2009 19:32 10144 10111111 33 Existing 2/9/2009 19:32 10144 10111111 132 Existing 2/9/2009 … |
| | this code is used to insert one record....how do i insert multiple records?? [code] Set connect = CreateObject ("ADODB.Connection") connect.open "DSN=OPTUMETL;Driver= Oracle in OraHome92;Server=urnts1.uhc.com;UID=OPTUMETL;PWD=OPTUMETL" Reporter.ReportEvent 0, "Database connection", "Successfully connected to URNTS1" Set objRecordset = CreateObject("ADODB.Recordset") ' Stmt to execute the code query="INSERT INTO STG_CARE.ASSESSMENTANSWER(ANSWERID, ANSWERGROUPID, ANSWERTEXT, DISPLAYSEQUENCE, ISEXCLUSIVENO, ISEXCLUSIVEYES, … |
| | Hi all. can u suggest me a way to insert values stored in a html table into oracle database using JSP code?Any help would be worthy..  |
| | Hi, Could someone please tell me how to get all the tables in one program/file so that i can run them as one. Please very important..thank you |
| | Hi, All. Actually i m creating a program using C# which connects to the database (oracle) and checks for the given table "OPC_GROUP". if the table doesnt exists then it creates the table else it updates all field with provided values I used following command to query [CODE]cmd.CommandText = "SELECT … |
| | Dear All, This is my first thread. We are porting an application from unix to linux. The application is to be connected oracle 10g and access the database. I am getting the linker error as follows /usr/bin/ld: cannot find -lexc collect2: ld returned 1 exit status The make files flag … |
| | I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true … |
| | I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex: select ss_id from id_table This will return all id's from this table and they are a length of 9 digits, i need to return just the last … |
| | I have two tables, say t1 and t2. t1{ txn_id varchar status varchar } t2{ txn_id varchar date Date } I want to built an update query which will update t1.status='X' with join condition t1.txn_id = t2.txn_id and t2.date < sysdate. Please let me to build an update query. |
| | i ve 1 table named 'A',it contains many attributes in 1 attribute the values are stored like this [COLOR="Red"]"Q108:5380;Q208:5380"[/COLOR] this data present in table 'A' should be entered in table named 'B' in two fields named B1,B2 as B1 B2 Q108 5380 Q208 5380 like this in two columns this … |
| | I am doing the following report. Write a report for a large bank on the benefits that cloud computing can bring to their database system (Oracle). Could anyone tell me I can find informaion to help me do this report?  |
 | I'm getting ready to start a project in my Software Engineering class and I've been assigned the role of Analyst. I will be contacting the "company" to begin the process. If Im remembering my System Analysis class correctly I need to come up with some good questions to ask the … |
| | hi everybody my database is in oracle 10g on linux. This is on a temporary server. I am trying to connect to this database using vb 6.0. how to do it? Advance thanks regards JAIMOHAN |
| | Hi Guys, for this time, i need to display blob from oracle database into my picturebox...the connection to oracle database already done, i can display the userid and username in textbox but the image still cannot display in picturebox...how to do my friend?...plz help me... |
| | Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change … |
| | Sir, I have developed an application in VB6.0 and back end as ORACLE8i . I would like to know how to "Deploy" it OR How do my application detect my Oracle dB automatically? |
| | I am a contract programmer/analyst living in Florida, and working at a large site with a complex blend of mainframe, Unix servers and PCs running Windows. I support Legacy mainframe systems, and Oracle Financials on the mid tier. I program IBM Assembler, COBOL, FORTRAN, PL/I, Unix scripts, PL/SQL, BASIC, PASCAL … |
| | Hello. I have a question and I need it's naswer. I am new begginer with Phyton, and I would like to know how I get from table that located in DB (Oracle), a specific value into my Phyon varaiable. Say I need to get from table in DB named "W_Keys" …  |
| | I'm getting the following exception "ORA-24960: the attribute OCI_ATTR_USERNAME is greater than the maximum allowable length of 255" when using Environment:createConnection. I'm using VisualC++ 8.0 and Oracle 10g R 10.2.0. Below is the snippet of code that creates the problem:[code] #include <iostream> #include<occi.h> using namespace oracle:cci; using namespace std; try{ …  |
| | Your web based ordering should work as follows: 1. Authorized customer must be able to place his online orders. 2. Authorized customer MUST log in first before making any transaction. If the login is invalid the customer access is denied and a message is displayed to the customer “ACCESS DENIED” …  |
| | hello! How can I display if the query results more than one value? For example, how can I do a query that produces all pairs of salespeople who are living in the same city. Thanks in advance. |
| | Hi , I'm using oracle 10g and vc++ 8 .Net 2005. Can anyone help me out in loading oraocci10.dll dynamically. when applcation run that time "This application has failed to start because oraocci10.dll was not found. Re-installing the application may fix this problem." popup display. I also copy oraocci10.dll ,oci.dll,oraocci10.lib,oci.lib …  |
| | I am using PHP 5.2.5 to insert record into Oracle 9i. For my database input I was getting two duplicate record inserts when I only needed just one record. Here is what I had: [code] require_once('oraConnect.php'); $query = "insert into cityTable values (1, 'George')"; $stmt = oci_parse($db_conn, $query); oci_execute($stmt);[/code] After … |
| | Hi all, I need some favor from u all regarding to connect remote oracle databae via network using vb.net......for info as below:- IP server : 172.19.30.10 Database name : minedb user : own Password : ownmy Please help me...thank you  |
| | I want to connect to sybase from java using jdbc:odbc bridge.. Which driver should I use like I have used "ODBC for Oracle" Plz help..  |
| | Hi folks, I want to access Oracle 9i table "emp" in Java... I do not know what driver to use .. The name of the Oracle database under which "emp" falls is "Oracledb" I do not know what the connection string is? Pls help... |
| | I have a stored procedure in oracle which has 2 in parameter and 1 out parameter. One of the in parameters has default value given. I want to call this procedure through java without specifying value for the in parameter which has default value given. Any idea, how to do … |
| | I have an apllication to verify the user identity using database(Oracle 9i).I used JSP for page design & servlet for interacting with the database.I made necessary changes in the web.xml file & saved the .class file in classes folder and servlet in src folder all of which lies under JSPMultipleForms …  |
| | Hi, When I am connecting to net after browsing for 10 mins I am getting the following message "Host Process for win32 Services has Encountered a problem" after which I am not able to access the net anymore. Also one more thing the amount of data receiving during net connection …  |
| | Hi guys I am an electronic engineer doing mostly embedded device programming. Lately I want to switch fields to become from a half behind IT guy to a full IT pro. The two field I am interested in are: 1. Embedded linux development 2. Oracle DBA (specialize in tuning) From …  |
| | Hello everyone. Happy New Year. correct coding for connectivity of oracle database with VB 6 or VB.Net Thanks |
 | |
 | Hey everyone! =) I'm starting an Application Development club at my college! However, there are a fair amount of programmers with multiple backgrounds who want to be a part of the club and partake in some of the Software we will create. Most of the people who are joining the … |
| | Hi, I would like to automate some of my actions on command prompt using perl. can u plz help me how to start with it. Like I want to connect to oracle database and run a sql query. How do I do that? Here are the steps that I need …  |
 | Hi! Sometimes while browsing, suddenly I stop getting sites, but I am able to ping sites. If I reboot, it starts working correctly again. Here is my HJT log- Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 15:12:52, on 18-10-2008 Platform: Windows Vista (WinNT 6.00.1904) MSIE: Internet Explorer v7.00 …  |
| | hi, any help will be appreciated. I use Oracle discoverer plus. recently I tried to build a running total (average) calculation using the template provided. I defined 10 previous observations for this purpose. discoverer performed the calculation but the problem is with the first 9 (in this case) observations of … |
 | Sorry for the simple question... But please i need help from you guys... How to import and export the database in oracle..iam have been using oracle 8i in my computer... im completely new to this environment... please help on this.. Thanks in advance... Shanti. |
| | In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary … |
| |
The End.