2,627 Topics
 | |
| | dear frnz... There is some problem in d code in one of my form... m having a table as Billable in oracle db. M using Oracle 10g. M done with the coding part..i mean all kinda validations bt when i try to save the data in table..it gives me the …  |
| | Hi all I finished a Graduate Diploma in Computing last year - with majors in programming (VB6 and Java) and database management (Oracle 9i, SQL) and haven't been able to get IT work because of not having professional IT experience. There are lots of IT jobs around but everyone wants …  |
| | hello frnz...How to code for a login form by taking data from Oracle db? M having a table Employee having attribute as emplogin and emppwd...from there i want to check that whether the user has entered the correct data or not... I mean i want to match the entered data … |
| | I have a JSP that works with an Oracle 9i database. On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very … |
| | I have an Oracle 10g application, built using Oracle PL/SQL Toolkits and PSPs, using an Oracle database with an HTML front-end (hosted by an Apache web server). When using the WPG_DOCLOAD package to add attachments to the database, the mime type for ".msg" files end up being application/octet-stream rather than … |
| | hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives … |
| | Hi all! I really hope someone can do a huge favor and help my group out! We are students and we are trying to complete an assignment to create an interface page using jsp and oracle. Using XP pro we have installed all of the above. We then configured apache …  |
| | Recently, I accidentally clicked on a link to install something while searching for some comic stand ups. I don't know if the download completed but my scan is advising that there are four infected file, which I cannot find. There is no specific re-direct or pop-up that happens over and …  |
| | How to write a procedure which takes integer N as its IN parameter and print a number series (up to N) in the Following format. 1 2 2 3 3 3 4 4 4 4 : - - - N N N N N…………N |
| | Hi I'm migrating from Oracle Sql to MS Sql. I'm trying to write an mssql query that will pull all rows from a tableA but only if row in tableB = apple. In other words the table might look like this: tableA tableB Joe apple Joe orange Joe peach Fred … |
| | can any one Suggest me a good E-BOOK for SQL server 2005?? |
| | this is the oracle GUI [code] import javax.swing.*; import java.awt.*; import java.awt.event.*; public class OracleGUI extends JFrame implements ActionListener { // Define constants public static final String GET_QUESTION = "I will answer any question. Let me know yours.\n" + "Type your question in the following and hit Submit."; public static … |
| | Hi I have two databases ...1st is server database which is in MySql and 2nd is local database which i will create in oracle. I want to have some of fields of 1st database to be populate in in my local database which should be refreshed automaically ... plz let …  |
| | is it possible for a trigger to handles two tables ? my question, "Write a PL/SQL trigger that, on the insertion of a donation, will set its bloodGroup to the donor's blood group if the donationType is 'whole' or 'platelets', and null if the donationType is 'plasma'." and my trigger … |
| | hi i m new here.. i m sorry i dont know where should i post my problemm... but i hope somebody will help me... i m student of BS(CS) i m confused in ..what should i attempt as my final project.. i m intresting to do in VB.NET and SQL/ACCESS/ORACLE.. … |
| | Hi, I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation? Thanks |
| | Hi, I use VB6 with Oracle database. I also use Adodc and datagrid for retrieving data from database. If i do search with [inlinecode]Select.....Where name IN(LIKE) '" & Text1.text & "'[/inlinecode] does return nothing. I have to type exact value be searched. Why do you think that IN or LIKE … |
| | Hi there I am creating a system where I link a .net app to a oracle db and am currently working on linking it to the database so that I can add new users for oracle here is my code: [CODE]Imports system.Data.OracleClient Public Class Form1 Dim OracleConn As New OracleConnection … |
 | i'm creating a form for my db and i need a code for the when_button_pressed for update one or more columns in a single row . thanx |
| | i have installed oracle 9i sql but while installing forms & reports it gives errors to run sql/plsql. pls explaine me the right steps to install oracl 9i & forms n reports. so pls help me that i can run both sql & forms reports. |
| | Hey, I've got a question on how to hold querystrings to use later on. First of all, I'm using ASP.NET c# with an attached ORACLE server and I am working on making a very simple forum-based web-application. I currently have one page which shows the sections ( which are in …  |
| | Dear all, I'm quite new in this malware-spyware-trojan etc. deal. I received a spam mail and unfortunately opened it and all the troubles started ever since. My PC had Panda anti-virus Platinum (subscription paid) and Spy-Bot S&D updated and the system immunized. Since I opened this mail, all hell broke … |
| | hello, i'm fairly new to oracle, but i pretty much get it. anyway i've created a table using this code : [CODE]create table BanquetReservation( ResNo SMALLINT NOT NULL, Restriction varchar(30) not null, ResType varchar(10) not null, DateOfEvent Date not null, NoOfPeople SMALLINT NOT NULL, EndDate Date, StartDate Date, SSN CHAR(9) … |
| | Hello, I have a requirement to fetch data from a database and store into another database. More explanation goes as follows: I have a web application deployed on an application server. The JDBC connection fetches data from a oracle database. Now I have a need to fetch data from a … |
| | Does oracle plsql has PROBIT function inbuilt? is there any way i can implement it in plsql? this function is related to probability theory |
| | <URL SNIPPED> This site contains 2000+ ebooks on php, Java, access, .NET, c#, UML, Perl, c++, linux, sql server, asp.net, Oracle, db2, xml, javascript, unix, flash, cisco, excel ... |
| | i have to get days of that particular month , that is if i give dates between different months like ex: 25-FEB-2008 and 05-MAR-2008 in this i want get 5 days only not 10 days |
| | Hi, I have a question pls clarify it. If a table is created and grant, index, triggers, synonyms etc are defined on the table. what happens to grant, index, triggers, synonyms etc if the table is dropped. What is the data dictionary needs to be checked to validate all these … |
| | Hi, I have a question. Please help me out. What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it … |
| | hello!!! could anyone tell me how can i use php with oracle?? i have installed wampserver and oracle 10 (oci10) but it doesn't work, i think they are incompatible (wamp is only for oci8) what other php packet could i get for oracle 10? what is your advice? thanks !! |
| | Hi, How can i call a Oracle Stored procedure in vb6? Stored procedure : [code]ADD_SP (1, '1', 1, 1, 'abc')[/code] Thanks |
| | I get this message when I try and log into the work database, does anyone know why? I know my login and password are correct because I can login using someone elses computer. Loading JDBC driver oracle.jdbc.driver.OracleDriver Connecting to JDBC access denied (java.util.PropertyPermission oracle.jdbc.J2EE13Compliant read) |
| | r CF MX 7 the CF admin setting for database queries timeout is set at 100. Because of this some of my queries timeout and give me back a timeout message. I am trying to overwrite it in my cfquery working with Oracle 9i: [code] <cfquery datasource="cityOra" [color=red]timeout="300"[/color] name="queryOne"> select …  |
| | Hi, I use Oracle database with vb6. [code]Label6.Caption = rcsetFran.Fields(0)[/code] generates 'Type mismatch and Variable uses an Automation type not supported in Visual Basic'. 0 is a autonumber column. Solution is to use 'Use a variable of a type recognized by Visual Basic'. If i do this, i cannot use … |
| | hi can anyone help me out in suggesting a way to connect oracle and VB6.  |
| | Please mail me the procedure for Java Oracle Connectivity. <snipped email> |
| | Hello everyone, I am completely new to this website and happened to have come across this while browsing. I am stuck up in my project and just need some help. I am developing a system for my client which is a non-profit organization htat run local trains in our area. … |
| | Hi, What configs i need to do to connect to Oracle 10g? I use wampserver. Thanks |
| | Hallo everybody, newly I installed OracleUnivEx 10g, and also I am able to connect to Oracle by its own Web-GUI, but the problem not recognising the MySQL commands like "create database "db_name"" and others like SELECT, INSERT, and ... any idea please? how to create database in Oracle and modefy … |
| | We have given a project at school, we have to submit ERD next week... the project is as followes..... Software Experts(SE) is a consulting firm that specialises in creating custom software application for clients. When a client approaches SE with a project, the management at SE determine the staffing needs … |
| | Hi frnds, i want normalised tables for airline reservation system.my project date is due after 4 days.so plz help asap.it should do all works like add flight,book a ticket ,report generation etc. |
| | Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another … |
| | Hi, What do i need to do to send SMS message or Email via Oracle 10g database? How do we do that? Thanks |
| | I have the tutorial running with a entire database displayed. I am working with the tutorial at: [url]http://www.netbeans.org/kb/articles/mysql.html[/url] The above tutorial creates a jDesktopAPP. with components bound to the table. I am trying to add a button (basically). I am in the process of understanding binding. the program loads with … |
| | I'm new to asp.net and I have an oracle stored function with 3 input parameters that returns a string. The function is one that validates a user. I want to validate my users from Oracle. I'm trying to use the sqldatasource component to interact with my stored procedure but I … |
| | This what i do; Can anyone tell me whay i receice an error. 1- Run "SQL Command Line". 2- [inlinecode]connect / as sysdba[/inlinecode]. "No error". 3- [inlinecode]@?/rdbms/admin/utlmail.sql[/inlinecode]. "Created and no error". 4- [inlinecode]@?/rdbms/admin/prvtmail.plb[/inlinecode]. "Created and no error". 5- [inlinecode]GRANT execute ON utl_mail TO SYSTEM;[/inlinecode] "No error" 6- Open my "Oracle … |
| | I am working with the tutorial at: http://www.netbeans.org/kb/articles/mysql.html can any one help me figure out why I can not set a query with this method? entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory ("splashbookdbPU").createEntityManager(); org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance (splashtemplateda.SplashTemplateDAApp.class).getContext().getResourceMap (SplashTemplateDAView.class); query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery (resourceMap.getString("query.query")); // NOI18N list … |
| | I am working with the tutorial at: [url]http://www.netbeans.org/kb/articles/mysql.html[/url] The program works great. untouched the program displays the entire database that is a result of of query.getResultSet(). I added a combobox,textfield,and a button with an action. I dragged and droped an additional: searchEnityManager1 bound to the preexisting splashbookdbPU searchQuery1 (bound to … |
| | Hi guys, Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem? Thanks [code] CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP IS -- cursor1 CURSOR cursor_1 IS SELECT ...... rec1 VARCHAR(15); -- … |
| | Hi, Where is the mistake? It doesn't work. thanks [CODE] CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME BEFORE INSERT ON A_SIPARIS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE; FOR EACH ROW BEGIN IF CURSOR_TARIH%NOTFOUND THEN INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1'); END IF; END; [/CODE] |
The End.