- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
A bit of everything...
- Interests
- Reading, Travelling
- PC Specs
- Windows
Hi I have written a procedure in PL/SQL to get values from user and then I am updating the same in a table. This worked fine 1st time but its just not showing the new values inserted by the user. The field which should be updated with the user value … |
|
Re:
HI Guys These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this . Select * from Amount_Paiad where CusID IN ('34343','34343','090094') There is no issue in query.Problem is how many values I can enter … |
|
Re:
hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it.. |
|
Hi, I am working on a report where I need to split the rows and update put it on a different column. For e.g. Policy No DriverName 123 John 123 David 124 Matt 125 Phil 125 Peter I need to split the data as per the policy number and instead … |
|
Re:
I need a query that will find for example in the given table Distinct Col1, with highest Col3 [CODE]A X 1 A Y 2 A X 3 B Y 2 B Z 4[/CODE] So the result should be: [CODE]A X 3 B Z 4[/CODE] |
|
Re:
hi... I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field??????? |
|
Re:
Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee |
|
Re:
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 … |
|
Re:
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 … |
|
Re:
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 … |
|
Re:
So I've been trying this for a long time and I've given up. I can't code it myself and no examples are helping. I want to log on to a website and return some text from it. The returning text part won't be hard, the logging in is the problem. … |
|
Hey Guys, I am Yashodhan from India. I am Oracle Certified Professional :cool: . Name :- Yashodhan Nickname :- Yash Height :- 5 feets 7 inches Weight :- 60kg My hobbies are traveling, reading and chatting. Yash |