[oracle] Forum Topics

Iam using windows 7 32 bit and Oracle 11g SQL> spool off SQL> host type c:\spool.txt The system cannot find the file specified. help me to solve the above ploblem

Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))

Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …

Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …

sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …

Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved …

Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …

sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover?

I just use this code to input data to oracle database from vb.net. Try Dim mstream As New System.IO.MemoryStream() PictureBox1.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim arrImage() As Byte = mstream.GetBuffer() mstream.Close() query = "INSERT INTO ds.students (ID,NAME,PIC)" & _ "VALUES (@ID,@NAME,@PIC);" Dim cmd As OracleCommand = New OracleCommand(query, con) cmd.Parameters.Add("@ID", Convert.ToInt32(TextBox1.Text)) cmd.Parameters.Add("@NAME", Convert.ToString(TextBox2.Text)) …

Previously I used vb.net with mysql database and successfully added data from insert query. In that senario my sql code is like this : INSERT INTO ds.students (id, name,pic)" & _ "VALUES (@id,@name,@pic) Now I used oracle database with vb.net. When I run program it shows: "ORA-00936 - Missing Expression" …

heY guys, I just step to oracle database system. so I'm new to this. I'm trying to make connection oracle db with vb.net. I saw below connection string on web. But I dont know it's keywords. So please teach me. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); uid=myUsername;pwd=myPassword;

Hey, I have been reading Java oracle tutorials. I read this thing. Suppose, for example, class MsLunch has two instance fields, c1 and c2, that are never used together. All updates of these fields must be synchronized, but there's no reason to prevent an update of c1 from being interleaved …

Hello, I have the below case. CREATE TABLE "PRBT"."TM_TABLE_1" ( "NID" NUMBER, "STRNAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, "NORDERCODE" NUMBER NOT NULL ENABLE, "NSTATEID" NUMBER DEFAULT 1 NOT NULL ENABLE, "STRDETAILS" VARCHAR2(256 BYTE) DEFAULT NULL, "STRAUTHOR" VARCHAR2(128 BYTE) NOT NULL ENABLE, "NPICTUREID" NUMBER DEFAULT NULL, "STRLATINNAME" VARCHAR2(512 BYTE), "STRLATINAUTHOR" VARCHAR2(512 …

I got tired working on that part of code for 3 days and searching on the internet please I need help to know HOW TO use auto complete textbox1 and use its value to set the value of textbox2 and textbox3 below code public class PopulateProduct { public string ProductDesc …

Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!

I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands: select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY') from f_promotional_menus where code=110; I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing …

Hello All, I am fairly new to Vb.net. I have experience in MS Access and VBA. I am trying to connect a remote Oracle Database through vb.net but getting the below error. But, the same Oracle database connecting with the help of SQL Developer. Can any one please help me? …

I'm running xp pro with outlook express version 6. When I receive emails in the inbox and choose to delete them they just stay there. I can shift delete but just delete does nothing. When I right click and go delete that also doesn't work. Can you please assist. Thanks.

I wan to call oracle database function I tried this but i am getting error `ORA-06550: line 1, column 7: PLS-00221: 'F_GET_DESC' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored` public void Get_Desc() { string oradb = "Data Source=source;User Id=myuser;Password=ss;"; string CommandStr = …

hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance

I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so …

I have tried to display the names of table in oracle database in visual studio 2012 in combo box but i am not sure why it is not displaying private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { con.Open(); OleDbDataAdapter oda = new OleDbDataAdapter("SELECT table_name FROM tabs where table_name Like …

<select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map"> SELECT ID, SUM(VALUE1 + VALUE2) Total FROM tableName GROUP BY ID </select> Returns below result in sql ID, Total 1 (null) But when returned in Map result in myBatis returns {ID=1} where as Total is missing. How to get the column with null into the result …

Hi, Can you guys reccomend me some good oracle sql journals? Thanks

Hello, What are the different areas of databases I can focus on for my project? Thanks,

Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro

Help me :) I want to display the text file in JTextArea but how ? and i want to attach this is searching button.

FROM: ORACLE 9i Give the SQL statements that determine the following: 1. Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') 3. Which books are not in Fitness …

Hi I have written a procedure in PL/SQL to get values from user and then I am updating the same in a table. This worked fine 1st time but its just not showing the new values inserted by the user. The field which should be updated with the user value …

Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> Select <column1>, <column2>, FOR Lcntr IN 1..12 LOOP CASE WHEN Lcntr THEN .... END END LOOP; FROM <table> …