Recent content by kalyan

I think, there is no way of bypassing that screen if you run it interactive mode. Try running the report in batch mode.

The VB program is required to open a word document and search and replace a particular string in the document. The search/replace operation is also applicable to headers and footers. To implement this Wordbasic commands are being used in the VB. But,the program is unable to do search/replace...

My requirement is as follows:<br> I have a list of text files. I have to insert those text files in between dat fetched by the report query. I've to print the whole output to an RTF format file.<br> <br> My strategy:<br> <br> I Used formula columns whose property Read from File set to TRUE. I...

Hi,<br> If you try the order by clause with Descending option, you get the DEF in the beginning.<br> SELECT DISTINCTROW First(Products.Manufacturer) AS [Manufacturer1],<br> Count(Products.Manufacturer) AS Amount1<br> FROM Products<br> WHERE Search_Key LIKE '#PN4#%'<br> GROUP BY...

Hi,<br> You can try something simpler.<br> <br> Select projectid from mytable where fullname = someone1<br> INTERSECT<br> Select projectid from mytable where fullname = someone2;<br> <br> Good Luck<br> Kalyan<br>

May be this will help, though it is a long sql statement.<br> <br> select trunc(date2 - date1) Days,<br> trunc(((date2 - date1) - trunc(date2 - date1)) * 24) Hours,<br> trunc(((((date2 - date1) - trunc(date2 - date1)) * 24)<br> - trunc(((date2 - date1) - trunc(date2 - date1)) * 24)) * 60)...

If you know the person id for whom you are going to pick up data then you can you this peice of PL/SQL <br> <br> Declare<br> Cursor cr_pid (vc_person In persons.Personid%type) is<br> select address, name<br> from persons<br> where personid = vc_person<br> order by seqnum DESC;<br> rec_pid...

You can try running the report in batch mode i.e. Auto Print. Set the sytem parameters PARAMFORM to NO and BATCH to YES. The report will be printed automatically either to a Printer or to a File - RTF file. For this set the parameter DESNAME - name of the online printer or file name and DESTYPE...

If it is not a very regular process. Open dbase file with excel and save as CSV. Using SQL loader, you can load into the Oracle database.

Iam new to data warehousing concepts. But I've good background and experience in Oracle developemnt. I want to know in detail about <br> STAR SCHEMA<br> TECHNICAL KEYS<br> Any help in this regard will be highly appreciated.<br> <br> Cheers<br> Kalyan