Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
0 Endorsements
~3K People Reached
About Me

A bit of everything...

Interests
Reading, Travelling
PC Specs
Windows
Favorite Tags
Member Avatar for yash_792

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 …

Member Avatar for mcglk
-1
219
Member Avatar for Tank50

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 …

Member Avatar for Prateek nandan
0
493
Member Avatar for RvSon

hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it..

Member Avatar for saideepak89
0
129
Member Avatar for yash_792

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 …

Member Avatar for NeverLift
0
67
Member Avatar for peanutz

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]

Member Avatar for 1stDAN
0
123
Member Avatar for johnsign11

hi... I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field???????

Member Avatar for yash_792
0
138
Member Avatar for kartheeee

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

Member Avatar for NeverLift
0
135
Member Avatar for ajotikaramrita

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 …

Member Avatar for sudhanshoo
0
189
Member Avatar for axas

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 …

Member Avatar for tesuji
0
136
Member Avatar for Allophyl

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 …

Member Avatar for yash_792
0
144
Member Avatar for gsingh2011

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. …

Member Avatar for zachabesh
0
1K
Member Avatar for yash_792

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

Member Avatar for happygeek
0
28