1,488 Topics
 | |
 | 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? |
| | Hi guys I would like to know if there is a way for us to create a custom Oracle Profile in C# just like in MS SQL? |
| | how can i execute SQL query from javascript ? or how can i execute javascript from SQL query?  |
| | hello everyone Could anyone kindly tell me about a script that backup my Oracle XE database. I have user schema and it has tables with data and I want to backup them. I hope someone tell me how. I want to do it inside a button so it can be … |
| | 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 … |
 | 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 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, Can anybody tell me that how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..  |
| | 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? |
| | 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 |
| | 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 … |
 | 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. … |
| | 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 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...!! |
| | 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 … |
The End.