Posts by debasisdas

try to find in MSDN
or u can also fine those by little web searching.

that feature is not available in VB 6.0 .
If u want use that u need to use 3rd party tool. OSEN XP SUTE

what bout try yourself before ask for help and if possibel posting your code instead of asking for complete solution.

I think in the specified database there is no relationship between the above two tables. If there is no relation how do u expect it to maintain / enforce referential integrity

You want to do that using VB 6.0 ???

As you are using Visual Basic 2005 as Front-end ,you should have posted the question in VB.NET forum .

try to write a script for this
or
a better option would be to write a cursor and then drop the tables .

dear karan to solve the problem you are facing just follow the process described above and u you get a exported file with extension .DMP

next u can import all of your tables from that fiel to re create your entire database or only specific tables (depends on type of export choosen).

any where u need to run your application just use the IMPORT utility of oracle

SQL> host

import [EMAIL="username/password@hoststring"]username/password@hoststring[/EMAIL]

then just follow the steps as prompted.

Yes that is very much possible to do in oracle using PL/SQl.
for that u need to use dynamic SQL using EXECUTE IMMEDIATE.

if oracle was installed on d drive how is it possible that data was in othere drives.

if oracle was intal;led in D drive means database was created there only .so all the data must be stored there not in other drives.

can you please specify what do you mena by write my data onto different Hard Drive

can you please specify what exactly you want to do. do u want to write data to any file ???

can you please specify what exactly is the error you are getting, for my reference.

try to frame the recordset dynamically by passing / framing query at runtime .

can u kindly post what is the difference in the result between the two.

it never happens that if--ehen and case will return different result.

you just need to enable and disable the controls on specified event.

store all the question and choice answers in database along with correct answer.
Also store the subject name with some flag setting. then randomly generate the numbers with or without option for ths user to choose the subject.

Hi Zangle ,
welcome to daniweb.

Hope you share your knowledge with the members ans enjoy a lot.

Welcome to DaniWeb.

Hope you enjoy here.

Welcome to DaniWeb.

dear jorge

welcome to DANIWEB.COM

welcome abord.

sorry dear the statment auto_increment is not valid in oracle , so it is not it oracle but in postgre sql .Restall u can aany way define in oracle.

hi dear
gleft52 welcome to daniweb.com

Of course you are in the right world.
any ways welcome to DANIWEB.COM

use the IN clause
or
simply write a procedure and pass the values. that u want to delete.

try using the predefined package dbms_lob to get some info regarding that.

Oracle supports creating a database of max size of 8 million terabytes using oracle version 10g .
In this version the max size a table space can be upto 128 tera bytes.

Hope this avoids all confusion

I don't think that is in ORACLE.

R u sure.

nice quote ......................

welcome aboard grandpa.

you are really young at heart.

Welcome!

care to tell me the name of that other forum?

If u really want to know then u can easily find out by little googling with may username.

ALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY';

PLEASE USE THE ABOVE CODE

the difference is too vast to explain here.

U can find the difference /answer to such theoritical question by a little Googling.

why u don't u use the wizard instead.
when u start a new project/form choose the data wizard.

only make some selections .no need to add any code

Do u want to take database backup or just copy the data to a text file ?

If u want the 2nd one then u can go with stupidenator

But when u say EXPORT it means taking database back up.
for this

SQL>HOST

U will get a black screen

type
EXP USERNAME/PASSWORD
THEN FOLLOW THE INSTRUCTIONS.

FOR HELP U CAN TYPE
EXP HELP=Y

Hope that helps you

When oracle is installed it creates a number user almost 20.
At the time of installation except the DBA accounts all others are LOCKED by default.
Which can be unlocked at the time of installation orlater on by logging in through the DBA accounts.

In your case it seems SCOTT account is locked.

u can login as SYS/AS SYSDBDA

then unlock the scott account
by

alter user scott identified by tiger account unlock;

Hope that helps u in solving your problem.

Its really funny to introduce my self here in the forum.

Even though I am a member of the forum for quiet a long time,
I hardly post here in the forum.

By the was I am Mr. Debasis Das .
I work as an Sr. Software engineer in a MNC .
My job profile is to design the database and develop the backend objects using Oracle PL/SQL.

Actually I am also a member of another forum where I act as the MODERATOR of the ORACLE & SQL SERVER forum.

Some times I also welcome new members.

Now lets see who is th lucky one here to welcome me.