Posts by debasisdas

222

Read books to learn more.

Hay Soma,

Welcome to Daniweb.

226

no matter where you hide, if you are a terrorist we will find you

Yes, Pakistan is not safe for terrorists any more.

240

try something like this

select max(id), name
from table_name
group by id
having name = 'NAME'
order by id

244

248

then why not use MAX(ID)

what exactly is last row ?

When you store records in database , it is not necessary that the last entered row will be always stored at the bottom of the table.

1. Place the database in Machine 1.
2. Set the database path in the setup to the desired path (Machine 1).
3. Install the application in Mac 2, Mac 3,......

It will work every where.

248

250

252

256

258

260

264

You need to store the database file in a network path and specify that path in your connection string code.

266

yes you have to use SELECT INTO....

270

try the following , may work for you.

DELETE ServiceID FROM tblServices 
where serviceid in (select ServiceID FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG')

What exactly you are trying to do ? using what code ?

You need to use COUNT and GROUP BY to get the desired result.

For the 2nd part of your question, you need to loop through all the tables in the desired schema and run the count() query using EXECUTE IMMDEIATE.

What exactly you mean by take dump of data ?

then go for this

SELECT TABLE_NAME,NUM_ROWS  FROM ALL_TABLES
WHERE OWNER = 'PM_CMP_MODEL'

272

Hi Abner,

Nice intro. :)

Welcome to Daniweb.

278

Try this.

SELECT TABLE_NAME,NUM_ROWS FROM USER_TABLES

Creating /altering table at run time is not a good idea.

why not create the table before executing any insert.

O' girl

You need to read books for all that.

282

i think your column name is post_type not post-type.

Is it possible to do this?

Yes that is very much possible .

What is the code that you are working on to achieve that ?

Hi Davy,

Welcome to Daniweb.

286

290

That mean all these days he was hiding in Pakistan.

The big question is Pakistan was with whom Osama or Obama ?

294

298

302

306

308

312

318

318

322