Posts by debasisdas

What auditing ?

create an app that ..............

Sorry, we don't do that.

Lets see what you have tried so far.

You have to prepare an insert script of desired number of records from desired tables.

Please post the code that you are working on.

What is the volume of data ?

If all the data contains number you can you to_number on the varchar field else use to_char on the number field.

How you assign the image, is is converted into binary before assigning ?

What is the table structure.

basically.....what is database??

You need to read books for all that info.

HI Justin,

Welcome to Daniweb.

HI Samuel,

Welcome to Daniweb.

Agree.

The question was "how to retrieve the deleted rows in a table after commit" not to retrieve rows from a dropped table.

Hit Google with proper key words.

Requirement is not clear.

Write an application that ...........

Who will write ?

FLASHBACK is used to retrive the dropped tables.

Use the following to retrieve the deleted and committed rows

select * from table_name as of timestamp to_timestamp(sysdate-(360/1440))

The above sample SQL will fetch the status of data in the table 6 hours earlier.

You need to take the list of constraints from user_constraints using a cursor and then frame and execute the following script dynamically.

alter table
   table_name
DISABLE constraint
   constraint_name;

In which line you are assigning data from controls to ado control ?

You need to increase the buffer.

You need to prepare a dynamic script for the same.

You need to check for the proper field names in the SQL statement.

Which version of oracle database you are using ?

What is the error message ?

Welcome aboard.

Should not be, but it may depend on how you use the column and what is stored in the column.

Day before yesterday i got an alert on my mobile for a transaction of $25 on my VISA credit card. Since i was traveling i got suspicious may be someone has stolen the card. Once i realized the card was with me only i had to call the bank to get the card blocked. Later i came to know someone has used the card to register some domain on godaddy.com. Since i blocked the card,now i have to pay to get a replacement card with tax.

it won't matter.

please send me the code for this.....

Sorry, we don't do that.

varchar(1billion) is not supported.

Try using JPG images.

What exactly is the error message ?

You need to download Oracle SQL Developer for Mac OS X platforms from here

I think PDD file format is not supported.

You need to sort the result set using Order by on the date column in your SQL.

ex

select * From employee order by date_of_join

Please read more here and here.

Please post what you have done so far.
Show some effort to get any sort of help here.

We do not supply code.

Welcome to Daniweb.

Welcome aboard.

Suppose you select Firstname from your combo box and enter Debasis in the input box .

So the the following line

Adodc1.Recordset.Find  combo1.list (combo1.listindex) & " = '" & dok & "'"

becomes
Step1.

Adodc1.Recordset.Find  Firstname & " = '" & Debasis & "'"

Step2.

Adodc1.Recordset.Find  Firstname = 'Debasis'

So you get the record where Firstname = 'Debasis', simple.
And since script is dynamic it will also work for Lastname = 'Das' and so on.

In which line of code you are inserting into database ?

I can't find.

what i see is two select and one update statement in your entire code.

Find more here.

try this.

SELECT * FROM SENTMAIL WHERE trunc(SENTMAIL_SENT_DATE)='01-OCT-2011'

You can't.

try this

Adodc1.Recordset.Find & combo1.list (combo1.listindex) & " = '" & dok & "'"

As already mentioned the barcode scanner works like a normal input device like a key board. so when you scan the bar code using the scanner any editable window having focus will be populated with the code. No need of any specific text box not even any application. Just ensure that the device is working properly and try that with a notepad.

What does the combobox contains ?

only firstname fields will work, the other fields are error. Because of line4 statement..

because you have coded it that way.

you have to select the field names dynamically from combo box at run time.

But in your you have hard coded that to firstname only.

Even if you are on the right track, you'll get run over if you just sit there.

It is better to use 3rd party components to generate bar codes.

Do you know how that .DLL works ?