debasisdas

[QUOTE=;][/QUOTE] To answer your question is beyond the scope of this discussion. You need to read books for all those clarifications.

[B]All men are not fools, some remain bachelor.[/B]

You need to take and export of the schema and import the same into the target system. you need to use the following commands for the purpose. EXP IMP please find the details [URL="http://download.oracle.com/docs/html/A97312_01/exp_impt.htm"]here[/URL] , [URL="http://psoug.org/reference/import.html"]here[/URL] and [URL="http://www.orafaq.com/wiki/Import_Export_FAQ"]here[/URL].

Do your home work yourself.

[QUOTE=rommelgenlight;830280] I have requested them if possible to increase it to 100 gig or even to terabyte.[/QUOTE] Go for Oracle , version 10g supports 8 million terabytes. I think that would be enough for all your data.

I want to breath some fresh air without having anyone to control my nostrils. So for me [B]Democracy[/B] is the only option.

You need to drop all the tables. Drop child table first and then the parent table.

You need to use a counter in the button click and based on the counter value decide what is displayed in the textbox.

You need to use the function [B]Replace[/B].

try the following sample code. [code]MsgBox("Do you really wish to quit this program ?", vbOKCancel + vbQuestion, "Confirmation")[/code]

What exactly you are doing ? Are you committing the transactions ?

you need to delete records of child tables first and then the related parent tables.

You need to read [URL="http://download.oracle.com/docs/cd/B10500_01/appdev.920/a96121/im_intro.htm"]this[/URL] and [URL="http://www.oracle.com/technetwork/database/options/semantic-tech/whatsnew/information-management-whitepaper-132860.pdf"]this[/URL] .

to drop the constraints you need to break the connenction to other tables.

You need to download the [URL="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html"]proper version[/URL] and install the same.

you want to connect to anexisting database or create a new one at run time ?

You need to understand first what inheritance is ? What exactly you are trying to do ?

How your tables are linked to each other ? I don't think they are.

You need to follow these steps. To Store ---------- 1.read the image file. 2.convert the same to binary stream. 3.store in BLOB field. To Retrieve -------- 4.read from db 5.convert back the binary stream. 6.display as desired in front end application.

You need to read [URL="http://psoug.org/reference/constraints.html"]this[/URL].

That is not possible to do using VB 6.0.

[QUOTE=Kalusingh;1104005]Please help me in the following matter:- vb6 Ado database connection vb6 Ado recordset connection show record add record in database delete record from database edit record from database find record from database and all sort of ado connection and add record in datagrid Please give me solution.[/QUOTE] That simply …

You can easily downlaod that from [URL="http://www.oracle.com"]Oracle[/URL] site.

you need to create views based on access tables.

There are many applications that can be finished in your time frame. Now it depends on you what you decide to develop.

if it is vb6 , use [B]adodb[/B] library for the purpose.

kindly post the code that you working on, for further assistance from our experts.

try this sample code [code]declare str varchar2(100); begin for i in 1..10 loop str:=str||' '||i; end loop; dbms_output.put_line( str ); end;[/code]

You need to take an export of the old user schema and import the same into new schema. You need to use the commands EXP(to export) and IMP (to import).

Please read [URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm"]this[/URL] , [URL="http://download.oracle.com/docs/cd/B10500_01/server.920/a96524/c18trigs.htm"]this[/URL] and [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#ADFNS012"]this[/URL].

Why you need to use IN , as MAX() will return a single record ?

Is that a task for me ?

You should be able to work with that one. There is no such restriction.

why you need to connect dynamically to any IP ?

What is the database that you are using ? How you connect to database ?

we are not a free code distributing agency.

Please find all the details [URL="http://www.oracle.com"]here[/URL].

There will be a DEMOBUILD.SQL file in oracle parent folder . Run the script that will create some default tables for you.

From where you are getting these ----[B]eno,ename,prono[/B], inside the trigger.

kindly recheck the code, check the values that you are passing to the log table. do post your table structure and code again.

[URL="http://bytes.com/topic/visual-basic/insights/701826-drawing-chart-using-mschart-control"]This[/URL] may help .

[QUOTE=fourty;1343225]Just as simmple as that. Thanks.[/QUOTE] Why don't you do it yourself then ?

why you need a case for populating the list. Why not use a simple FOR loop for the purpose.

If the connection type = basic --------------------------- If the DB is installed on your own PC then you need to pass oracle database name in the SID and localhost in Hostname. IF using TNS -------------- Provide the conenction name as defined in your TNSNAMES.ORA file along with username and password.

1. Use RGB unction to change color. 2. Use Scroll and Change event of the scroll bar.

You need to connect to SMS gateway for all that. Contact your Service provider.

you need to specify the name / ip of the server in the connection string also.

try using the following. EXP--upto version oracle 9i EXPDP ----oracle 10g onwards

for back up of oracle DB you need to use EXP or EXPDP (ORACLE 10G ONWARDS)from command prompt.

Please read [URL="http://www.dba-oracle.com/oracle11g/oracle_11g_new_features.htm"]this[/URL] and [URL="http://www.trubix.com/whitepapers/11gTrubixNewsletter.pdf"]this[/URL].