Search results for query: *

Hi! Are u using Parallel Server, if yes, then check the parameter : PARALLEL_MAX_SERVERS. This parameter needs to be increased too. thx, Kavy

Hi ! This should work: select add_months(to_date(max(YourDate)), -6) from <table_name>; The other previous will give u error : invalid character. To avoid this error, convert the max(yourdate) into date first and then use the add_months function. thx, Kavy

Increase the arraysize. set arraysize <n> where n be a number greater than 1000 thx, Kavy

Give a try to this: 1)shutdown the database 2) at the o/s prompt (oracle's default directory), give the following without any soace anywhere: c:\...>oracle_sid=orcl 3) start the database 4) try connecting now.

A global variable is automatically created when a variable is prefixed with the keyword &quot;global&quot;. So, when i say :global.g_empno :=:blk.empno; the global variable called &quot;g_empno&quot; is created and a value from the block &quot;blk&quot;, column &quot;empno&quot; is assigned to...

what is the error message u get?? Kavy

Hi Prosenjit, firstly, one has to decide what kind of table it is. wether it is a lookup table(master table) or any custom table. Based in this we can go to the next question : What kind of data will be stored, ie. how often data will be written to the table(insert), how often updated and how...

Hey! If u are talking about SQL*Plus, then goto Options Menu> Environment There, in the Scren buffer. Increase the size of Buffer length to anything beyond 1000(which is the default)