2,627 Topics
 | |
 | Please, help me! I am a student in Technical University in Plovdiv, Bulgaria. I must finish my graduation work very soon. For the purpose I must create trigger(actually a few triggers) at run time. For my graduation work I use Borland C++ Builder 6. I use BDE palette. I try … |
| | I want the list of columns whose datatype is "date" from mytable in oracle. how can i do this. which query is used t fetch such column names? |
| | Hi. I'm having a little trouble figuring this problem out. What I need the program to do is take an email inbox and print out only the Headers for each message. Assuming each max line length to be 1024. I can read the file line by line but I don't … |
| | Hi I recently instaled oracle11g but when i am opening sql*plus it's asking for enter username I entered scott then it's asking for password when I am trying to type password it does not type any thing and finaly it gives ora-25000  |
| | I have an excel sheet which has the ID of some users , i would like to check if those users exist in a table in database. What I usually do is, concatenate a comma to the end of each ID in excel using excel formulae and the run below … |
| | hi experts SELECT porh.segment1, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' THEN prall.full_name END directman_pr,[QUOTE]to get the dept.head[/QUOTE] porh.description, porl.line_num, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' AND poph.action_code = 'SUBMIT' THEN TO_NUMBER ( … |
| | Hi all, Wondering if anyone can help me with this issue. I am using a SqlSiteMapProvider (inherits from SiteMapProvider) to build a menu on my site from an Oracle DB. This menu is built according to the user type, ie, user type A's menu is different from user type B. … |
| | G'day, Just a simple question. Does MySQL Support Inheritance? I understand that both Oracle and PostgreSQL support Inheritance, but haven't seen anything in MySQL regarding this. Regards, TC |
| | I am using Eclipse and TomCat to a Oracle 10g database. Using SQL developer I can enter multi-language characters into the nvarchar2 columns. My application creates SQL update Strings that look like this: [code] update CLIENTINCUMBENT set UNITCODE = UNISTR('66'), EMPLOYEECODE = UNISTR('000607'), LASTNAME = 'Ыфтвууз', FIRSTNAME = UNISTR('Ощрфк'), JOBCODE … |
| | Hi, I can't find the missing thing in this code. "05-MAY-08" is in the table but, [inlinecode]( CURSOR_TARIH%FOUND )[/inlinecode] never returns TRUE. When i do manuel query it is ok. Thanks [CODE] create or replace PROCEDURE A_SIPARIS_EKLE_SP IS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT WHERE TARIH = to_date('05-MAY-08', 'DD-MM-YY'); … |
| | Hi, Im working on a stored procedure to get monthly reports from a table. For that i need to develop a logic to perform the following function: suppose i give a start_date and end_date, i need to get the months split up between these dates. for eg) if I give … |
| | Hi all, Can anybody tell me that how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..  |
 | Hello, Everyone. I want to get opinion in developing software project. I will be studying Oracle and will need to do a project using Oracle. Can anyone give any idea on what project I can do. It doesn't matter what language to be used as long as it used Oracle. … |
| | Hi experts, i developed javascript code that connects to ms acess database 2003. Everything work fine as it can insert,update and delete information from database. But my problem is that when i try to validate all my input text so as to ensure that my user must fill all the … |
| | Hi experts, i developed javascript code that connects to ms acess database 2003. Everything work fine as it can insert,update and delete information from database. But my problem is that when i try to validate all my input text so as to ensure that my user must fill all the … |
| | Hi all, I want to create a function in c# which receives a paramater (name of a field from a table in oracle) The function will have to return the distinct values of the specific field.I don't know how to insert the parameter into the [I]select distinct(parameter) from table [/I] … |
| | Dear all, I developed a web application and it is working fine, except for one issue. The application includes uploading files from a JSP to my servlet, and the issue is that i would like to have a limit for the uploaded files on the client side (before actually uploading …  |
| | Dear all, I developed a web application and it is working fine, except for one issue. The application includes uploading files from a JSP to my servlet, and the issue is that i would like to have a limit for the uploaded files on the client side (before actually uploading … |
| | G'day, I recently gotten my MySQL certification, and have been thinking about looking into oracle. Could anyone please recommend some decent reference material to look at? |
| | hi, i am facing problem at connecting c++ with oracle10g in redhat4 platform can you guide me to solve the problems. if you do that means i will really thank full to you. thank you at advance |
| | 1)CREATETABLEProject( ProjectNovarchar2(5)notnull,ProjectNamevarchar2(20), StartDatedate, FinishDatedate,PRIMARYKEY(ProjectNo)); 2)CREATETABLEAssignment( StaffNonumber(3)notnull, ProgramNovarchar2(4)notnull,PRIMARYKEY(StaffNo,ProgramNo), FOREIGNKEY(StaffNo)REFERENCESStaff(StaffNo), FOREIGNKEY(ProgramNo)REFERENCESProgram(ProgramNo)); 3)CREATETABLEStaff( StaffNonumber(3)notnull, StaffNamevarchar2(10), SalGradenumber(2)CHECK(SalGradebetween1and12), YearsExpnumber(2), ProjectNovarchar2(5),PRIMARYKEY(StaffNo), FOREIGNKEY(ProjectNo)REFERENCESProject(ProjectNo)); 4)CREATETABLEProgram( ProgramNovarchar2(4)notnull, Titlevarchar2(20), Languagevarchar2(20),PRIMARYKEY(ProgramNo), CHECK(Languagein('VB','JAVA','ORACLE','C','XML'))); for the code above, what type of integrity constraints will be on them? (how many do u think?) also; i've created this code (below) but there seems to be …  |
| | Hi, I am not sure if this the right forum... Please suggest on what should be the best design practice for running 10 instances of desktop based java applications (No Enterprise or Webcomponents) on different machines BUT still using the same database. Summary: a) Each application will do writes/updates to … |
| | I have been working on an old VB6/Oracle app to add support for additional languages. I got the on screen controls to work and can display the contents of the Database OK on the screen. Now I am looking at importing data with some columns in Cyrillic. I can read … |
| | Hello all, I have to design an ERD Diagram and a data flow model for a project assignment. I just want to know if I am on the right track. The question is as follows: "The short course institute runs computing courses for members of the public and IT professionals. … |
| | Hi I have two classes the first inherits the second which should retrieve records of a table found in an oracle database as a jtable but it display table header only! can anyone help me to know the problem please ? [code] import java.sql.*; import java.util.*; import javax.swing.table.*; public class … |
| | Hi there, I’m very new to ColdFusion and I’m still going through the learning process. I have a report to create in CF and I don’t know how to start: I have three tables in 2 databases: tblEmployeID with EMPLOYEEID, EMPNAME, MGRName (this is in SQL 2000) tblCategories with CODEID, … |
| | Many of the student don't know how to find connection string, if they find then there will be some mistake. it's a simple idea to find connection string try it. and vote for it how to find connection string of any database or any server like, access or sql or …  |
| | Hey ppl, I have this assignment at school, where they asked me to create a simple site for uploading and watching videos. I must use PHP, Oracle (ORDVideo precisely), but I don't have much info online. Anyone can point me in the right direction? I am using ADOdb to connect … |
| | Hi Guys! Am revising for my upcoming exam. I was trying a question in the past papers. It read: [INDENT]A power-tool hire company requires an object-relational (e.g. Oracle) database to record details of their tools and rentals. Customer details, including their name, address and telephone number, must be recorded for … |
 | The topic of certification surfaces every so often in technical circles--especially when job seekers face tough job competition. The value of such certifications comes into question versus that of years of experience. For experienced technicians and engineers, the opinion is that experience is the most important for landing a job. … |
| | hi guys >> i need ur help please >>> i ve created a login page which includes user name and password and i created a welcome page which contains the required codes for connection and verifying the username and password from oracle database .. when i run the login page … |
| | Somebody please help with this code. I have been tryin to calculate and display the total of the total output from an oracle database. Please see my code below and kindly tell how i can display the total. <?php $conn = oci_connect("Username", "pwd", "IP/tns"); $date=date('d M Y'); $total= oci_parse($conn, "select … |
| | Hi. I've been invited by Dani to introduce myself. Well, I'm a new-old guy. Been in IT for almost thirty years. I'm addicted to newsblogs (Newsvine, Guardian, Al-Arabiya, LeMonde, etc.) Usually you climb onto their forums by getting into the box at the bottom of the blogs but this is …  |
| | Hi, I'm a developer with little experience in J2EE. I'm working with an Application called Enovia Matrix, which is an N-Tiers System composed by an oracle database, an RMI server, some "thick-client" applications and a Web-Based interface. I develop using Eclipse, in which I imported the War File generated for … |
| | Hi all, Pls help me....i need to save picture from oracle database (blob type) into jpeg....i'm using vb 2005 with console application...After that i need to insert that picture into Other databasse...can anyone help me..tq |
| | How to connect c++ and oracle ? i am working on a project Multiplex management system using c++.... but it really tedious task to store and handle all data in file... please help me with the procedure...!! |
| | hey guys ok so i'm stuck with a logic error this program im writing requites me to we write my own hash table when pulling a pice it seems to add an extra index some how there fore it really shows up with dates in December. thanks for any help. … |
| | Hi team, 1)There are 2 independent AIX platform available with 10g database running on it Mainly-Production and the other test machine 2)There is 2 tables which needs to be brought down from production to test machine I know expdp/impdp plays the key<commands as below-correct me if the below command needs … |
| | Hey all ! I want to create a new data-type called 'Phone' so that I can use it when create a new Attribute, with its form is : xxx-xxx-xxxx For example : 123-543-8978 And when users want to UPDATE my table, they must enter a string with the same form … |
| | |
| | I have a problem with Oracle as well.. After i installed Oracle express.. I tried it for the first time and it worked. The next day, i tried to bring it up on my computer and i kept getting message that it couldn't connect to the server even though my … |
| | Hi, I have this source code and it is copiled without problems. But when I debug this program than it write error 24960. This is my program: [CODE] #include <iostream> #include <occi.h> using namespace std; using namespace oracle::occi; #define USER "SYS" #define PASS "****" #define DB "XE" int main() { … |
| | Here is my code for a JDBC program to do account transfer. I am having trouble with my transfer code. Can anyone help. This is urgent. [CODE]import java.sql.*; /***************************************************** class BankAccountTransfer { /** Make a transfer from two accounts owned by same customer. * @param custNum the 6-digit customer number … |
| | What I want to know is the difference between the development, scalability and cost of ASP.NET(C#) and Java. I know that in most cases Java is slower than C#. But how much slower? I also know that to run .NET we need Windows(excluding Mono). Will the cost of the license … |
| | Hi, I am trying to run some simple updates using java in Oracle(10g). I have a simple java program to do it. Running the code using Eclipse IDE. The strange thing about it is that the connection is fine. If I run a [B]select[/B] query, it works fine. However if … |
| | hi all I'm trying to write a procedure/function in pl sql that get the user's password, encrypting it with md5 algorithm and inserting it into the USERS table. any 1 knows how to do so? i know that md5 is not a good algorithm but i dont care cuz its … |
| | hi below is the code i am using to try and execute a pdf report. now the following code i saved in a separate file in the website folder itself. and in the form that contains the print button, when clicked i want it to execute the code in the … |
| | Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE … |
| | Hello. Im wondering if anybody can help me out on a problem I am having for my SQL class. I have been going round in circles for the last three hours and am about ready to give up. The brief asks that I design a query that performs a division … |
| | hello experts... i have a table employee and in it are attributes like name gender,birthdate...etc.. apart from this i want to automatically generate d employees age from d current date....how can it be done?? thankyou... |
The End.