1,135 Topics
 | |
| | Hello all I am new to the community and have been stumbing across a problem with my code. I have a program that is connecting to an oracle database. I am using the table adapter to fill a combobox to select a model. Then I am connecting to the database … |
| | 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. |
| | how to get server's ip address in store procedure in oracle |
| | i want to display 0.00 in field where the field is empty... Empty because there is no data in the table/records for particular input. and the report is display based on joins.. so please help me... |
 | Hi I need to write a sql script to split a string in two or more parts. e.g. I have a string: "tag: key1, key2, key3" I would like to use the ":" as a seperator and thus end up with two strings: "tag" and "key1, key2, key3" Is this … |
| | I want to find out the names of temperory tables from oracle database? |
| | i hav 2 make library managment system using 9i and oracle forms..can any1 snd me da projct so that i could get da idea.. |
| | i'm trying to figure out how to write a query like the following, but in a way that works: select * from (1,2) or select (1,2) ... the result i'm aiming for is 1 2 can this be done? |
| | how can i execute SQL query from javascript ? or how can i execute javascript from SQL query?  |
| | i want to creat database and table to store data by using form 6i. i am vb developer and there is very simple way. how this process in oracle 8i is completed? your help will appreciate.  |
| | I have installed oracle10g ExpEdition,it hasn't inbuilt table. I need oracle tables emp,dept,salgrade,mgr.If you have installed oracle9i , you can easily export the tables. I am describing the method. [ICODE]open command prompt type C:\>exp scott/tiger file="c:\emp.dmp" tables=(emp,dept,salgrade,mgr) [/ICODE] then go to c drive,You can see the exported emp.dmp file. Please … |
| | 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 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 ( … |
| | 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, 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] … |
| | 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? |
 | 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 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() { … |
| | 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 … |
| | 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... |
| | Hello, I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle? [code=sql]SELECT DISTINCT Job_ID, … |
The End.