[oracle] Forum Topics

Actually i am currently developing a website. Which involves oracle database access.... And my problem is that i am not able to access the variable from the home page or the login page from another page. please help in doing so,,, thank you,,

hello every one I am a student of CS and in this semester i have a subject DBMS, i haven't do any programming with sql till now, i am completely new to it, here i want to know that about different DBMS software. in our coll we have oracle 8i, …

How to create database in oracle. Is the tablespace and database same? Do we need to install client from oracle 9i? I have the code as follows Create Tablespace SCT_DATA Datafile 'sct_data.dat' size 10M online; and i come across the error as follows Create Tablespace SCT_DATA * ERROR at line …

Hi to all, I have downloaded the j2eesdk-1_4_03-linux.bin and installed in my system.It works good .I can able to start the server .It starts fine. By Using the below command: asadmin start-domain But when i do no how to execute the JMS program. Can any one tell me how to …

can someone tell me how to do this??? i have a product category in a combobox and the associated product codes in a list box. i'm using oracle for backend. the combobox on form loading shows the product categories from oracle database. but the product category is not a primary …

Hi all! I have the following situation - three tables in the db : - um_users (id, name) - um_roles (id, description) - um_user_roles (user_id, role_id) I load into a data set two datatables : the "users" one, and another one build on the other two, like this : [code=c#] …

Hi i am new in oracle. i am having a problem. i need to collect datewise max time and min time from my table "dailyAtt" here is the data formate in my table.. ID Code Ptime 1 2570 14/10/2010 1:00 Pm 2 2570 14/10/2010 2:00 Pm 3 2570 15/10/2010 7:00 …

Hi everyone, I will be really thankful if someone could help me out. I am developing a gui application ( based on java jdbc and oracle10g), where a user can enter queries retrieve data from that can perform selection projection join union. Till now I could perform only selection queries …

Hi everyone, I will be really thankful if someone could help me out. I am developing a gui application ( based on java jdbc and oracle10g), where a user can enter queries retrieve data from that can perform selection projection join union. Till now I could perform only selection queries …

what is wrong here? [CODE]ALTER TABLE valoare_lucrari( ADD CONSTRAINT fk_oferta FOREIGN KEY (id_ofertant,id_proiect)references(id_ofertant,id_proiect))[/CODE]

hello, I am novice in the field of visual basic. In my project i want to store and retrieve image from the oracle database from the FORM in run time. i don't know how to do. i read several articles on web. i hadn't got much idea and clear view. …

Hi guys, can anybody tell me where can i download oracle 9i, please send me some links, Thanks in advance.

Can anyone help me? Actually I want to lean Advance Java (J2EE), the problem is, to go further you should have two knowledge : 1. knowledge on RDBMS 2. knowledge on ODBC & JDBC however I have little bit knowledge on database, and SQL statements, after that everything is blank, …

Hi all I'm having a bit of trouble wrapping my head around exactly what hiding a class method does, can somebody try giving it to me in plain English? I'm going by the [URL="http://download.oracle.com/javase/tutorial/java/IandI/override.html"]Sun Java Tutorial[/URL] but I find the example a bit vague when it comes to the hiding. …

I'm going into my last year of a computer science degree, and after looking around at job postings for software developers I've noticed that *many* of them require knowledge of Oracle - something that I haven't yet learned very much about. So I was wondering if anyone could point me …

We have to do one data base project? They said that we have to use certain front end languages and oracle for the back end. We don't know much about any front end language. I hope if anyone could suggest us some so that we could learn it and apply …

encountering this error while calling the insert stored procedure from plsql. STORED PROCEDURE: create or replace procedure WLLINSERT (p_WLLPACKAGEID NUMBER, p_WLLPACKAGECODE varchar2, p_WLLPACKAGENAME varchar2, p_WLLPACKAGEDESC varchar2, p_SDATE DATE default null, p_EDATE DATE default null, p_STATUS varchar2, p_BRANDID Number ) is begin insert into WLLPACKAGE (WLLPACKAGEID, WLLPACKAGECODE, WLLPACKAGENAME, WLLPACKAGEDESC, SDATE, EDATE, …

Hi, I have downloaded a sample jms program from the below url and try to execute it in my system.But, it shows the below error.Can any one know how to execute the Jms programs in the system. [url]http://download.oracle.com/javaee/1.4/tutorial/examples/jms/simple/src/SimpleProducer.java[/url] Error: package javax.jms does not exist [code] import javax.jms.*; ^ SimpleProducer.java:90: cannot …

I'm using the HR@orcl learning account from oracle. ----------------------------------------------------- and I have the following question : Create a an SQL query to display the department, the number of employees for that department based on their salary, and the total number of employees for that department, giving each column an appropriate …

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OracleClient; public partial class _Default : System.Web.UI.Page { OracleConnection objConn; OracleCommand objCmd; String strSQL; protected void Page_Load(object sender, EventArgs e) { String strConnString; strConnString = "Data Source=pcrm195;User Id=wllnew;Password=wllnew;"; objConn = new …

how to store pictures in database using oracle??Is there any special data type???

the totally mess is going out here.............nobody is giving a perfect suugestion to anybody...........i have log in here to get som project ideas but.... i don't need the code i just need good idea n help in our problems of project i wanna to create dbms project in oracle 9i …

Hi all, I'm very2 new to JSP, I've give a task to make a search and pagination function for my project.... but look like it to tough for me.... here is my code... can anyone help me?? <%-- Document : index Created on : Jul 21, 2010, 11:40:54 AM Author …

Hello, I am having a problem. I am filling a datagridview straight from an oracle sql query. The datagridview is filling properly using this code. [code] Try cmd.CommandText = "SELECT *" & _ "FROM oracle database Dim da As New OracleDataAdapter(cmd) Dim DMdt As New DataTable da.Fill(DMdt) If DMdt.Rows.Count > …

i am bca final year student.i want to do my project in vb using dbms so please suggest me some project names which consists of dbms.i do not want any normal one like hospital or library.project must be easy with many modules . i will be very thankfull if you …

Below is code taken from [URL="http://download.oracle.com/javase/tutorial/java/javaOO/QandE/enum-answers.html"]Sun Java Tutorial[/URL]. From my reading of the code the first time this loop executes should it not populate cards[1] with the first card skipping cards[0]? I've tested the code in eclipse and it seems to work properly first populating card[0] so I'm hoping somebody …

How to update database table using commandbuilder without having Primary Key. We Tried this Attempt; [CODE]obj.con = obj.Class_DBConnection(); OracleCommand cmd = new OracleCommand(); string fromsrvno = "000000067334"; string tosrvno = "000000067350"; qryStr = "select distinct * from test_m_srvdetail where SDBM_SERVICE_NO between'" + fromsrvno + "' and '" + tosrvno + …

I am rewriting in Visual Studio 2008 c++ an application written in VB.NET that successfully connects to an oracle 10g database using OracleDataAccessClient.dll. I am trying to utilize the same dll in the c++ app though very unsuccessfully. In the project's Property Pages, I have successfully referenced the dll. In …

How to check whether two tables in SQL are the same using vb.net? Would u mind giving me the code? Thank you so much!!!

Hi, I am filling a datagridview with multiple columns from my oracle database. It has become necessary that I add a column with a checkbox. I figured this out. [icode] Dim cbPart As New DataGridViewCheckBoxColumn DataGridView1.Columns.Insert(1, cbPart) With cbPart .HeaderText = "PART" .Name = "Part" .DisplayIndex = 0 .Frozen = …

Hi, I´m new in forum. Im trying to change one project made in Oracle Forms/Rerports to CFML. I did somethings in CFML in 2003 and now I will return to it because I need time and dont want type lines of code. I have installed Railo and Eclipse and now …

i want to connect plsql server with asp.net using C# and want to show data of server in grid view. using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OracleClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object …

Please how can I write a query to display only the top three earners in a table in desc order e.g Emp Sal John 100 Jam 120 Abi 90 Jo 170 the query should display Emp Sal John 200 Jam 170 thanks

Hi all I shall be grateful if somebody can provide code for a live online exam(MCQ & subjective ques.) using .NET (prferably ASP.NET) with oracle/sql connectivity. Kindly rush as I'm in a great hurry. Thnx in advance >email address snipped<

I am not a developer, but I am trying to learn SQL to write reports for auditing our data. I want to extract empoloyee contact information, because I feel we are missing some CREATE_MIRROR_FLAG. I found the contact information on the per_contact_relationships table, but now I need to find the …

[CODE]public partial class Form : System.Web.UI.Page { private void connecttodb() { OracleConnection conn = new OracleConnection(); conn.ConnectionString = "User Id=WLL; Password=wll; Data Source=WLL;"; } protected void Page_Load(object sender, EventArgs e) { if(!Page.IsPostBack) { String CommandText = "Select DepartmentID,Department from its_department;"; OracleDataReader odr = GetDr(CommandText, ConnectionString); DropDownList1.DataSource = odr; DropDownList1.DataTextField ="Department"; …

[code]public partial class Form : System.Web.UI.Page { private void connecttodb() { OracleConnection conn = new OracleConnection(); conn.ConnectionString = "User Id=WLL; Password=wll; Data Source=WLL;"; } protected void Page_Load(object sender, EventArgs e) { if(!Page.IsPostBack) { String CommandText = "Select DepartmentID,Department from its_department;"; OracleDataReader odr = GetDr(CommandText, ConnectionString); DropDownList1.DataSource = odr; DropDownList1.DataTextField ="Department"; …

Hello guys and gals. As always any help is much appreciated. I am at a dilema. I am filling a datagridview with very lengthy results. Roughly 60k rows on average. I am filling them via an oracle database using a table adapter. The records then have a filter placed on …

hi,i m getting the following excption,though i hv properly set the classpath ,,, i m able to rum other programs,,,, plz help,,, [CODE] Exception in thread "main" java.lang.NoClassDefFoundError: admins (wrong name: a dmins/admins) at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632) at java.lang.ClassLoader.defineClass(ClassLoader.java:616) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:14 1) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at …

Hi everyone, can anyone tell me how to store record from datagrid to oracle database at run time. user have to enter one record in datagrid at run time and the record should be saved at button click in the oracle. manak chand :)

Hi ppl, I wanna write a supply chain management system using JSP and Oracle database. Anyone got experiences in coding SCM or similar systems in JSP? I wanna ask about the functionality aspect.

Hi, I have Oracle 10g installed in my laptop. I have currently inserted a Gridview and in this Gridview when i choose "Oracle Database" as my Data Source, I come across a form where I have to fill out the server name, username, and password. I do not know what …

Exception in thread "AWT-EventQueue-1" java.security.AccessControlException: acc ess denied (java.util.PropertyPermission oracle.jserver.version read) hi, i m building an online examination application. The code is getting complied .but it throws an exception.Below i m pasting d code as well as exception.plz help me. It is a simple program for login. It matches d …

I hit an overflow error 22053 while retrieve data from oracle database.One of the data type of database is number. After I insert floating point value into data of this data type, overflow error occur while retrieve data from database into datatable. This problem doesn't occured while the data's value …

SAP ERP system 1- SAP ERP is the leading ERP solution, particularly for large organizations, with over a 25% market share. The only realistic competitor is Oracle who have about half that. Microsoft are also a significant player, but largely for smaller organizations. Most of the rest of the market …

hi, there are 2 different database 1 database have the list of all the users and another DB only have the details of users who are logged in which is production DB. i have writthen below code but i am stuck over here plese do the needful. /** * */ …

Hi All, I am planning to write OCA 10 G this september. I am referring book PL/SQL programming by SCOTT URMAN. Other than this I want study material/dumps. If some one has please help me out with the same. Thanks in advance.

Consider the relation R(A,B,C,D), consisting of 100,000 tuples. Each page contains 10 tuple entries. R is saved as a heap with dense secondary indexes on B. Data is distributed randomly. The attribute B lies densely in [1, 100,000] i.e., each value in [0, 100,000] occurs in B. Consider these three …

Hi, I got reported that login page not working for our client asp.net 2.0 web application with oracle 9i db. Is there is anyway to debug the application which is running in my client web server with the source code available in my machine?, I like to know after clicking …

how to get server's ip address in store procedure in oracle