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 …

[QUOTE=;][/QUOTE] if you are able to create a temporary table of your 5000 records then you can either join these tables or you can pass these values into a sub-query for e.g. select * from amount_paiad where cust_id in (select temp_field_name from temp_table) Hope this is helpfull

[QUOTE=ravi sonaiya;1634856]hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it..[/QUOTE] Hi you can store images in oracle by using datatype as Bfile. it has a capacity of 4 gb of filesize. Bfile stores Binary data of external file upto …

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 …

Hi, Try this query, it should give you the desired result. select col1,col2,max(col3) from table_1 group by col1,col2 [QUOTE=peanutz;1268355]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 …

Post 2 is quite a sufficient reply. it'll help you add constraint to the column

Hi try this... select leaveno,fromdt,todt from leavetb where fromdt >= to_date('01-Apr-2010') and todt <= to_date('30-Apr-2010');

You need to be logged as sysdba only then you'll have sufficient previledges to create a desired tablespace...

Hi below query might help you acheive your desired results... select code,max(ptime),min(ptime) from dailyatt group by code; [QUOTE=axas;1306828]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.. …

Oracle is just not about programming language. you need to decide what you want to learn in Oracle. There are primarily two parts development and adminstration. For development you need to know SQL and PL/SQL wherease for admistration. SQL is lot simpler than any other programming language. For administration you …

Try start [url]www.yahoo.com[/url] to open yahoo site through commandline. Yash

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