Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 31
Search took 0.01 seconds.
Search: Posts Made By: debasisdas
Forum: Oracle April 12th, 2011, 12:45 AM
Replies: 3
Views: 2,759
Posted By debasisdas
What if you have to check the values in the...

What if you have to check the values in the column in a lsit of 10 or more values. How many times you will write OR OR OR ....?

That is the reason the values are check with IN (.,.,...) operator.
Forum: Oracle April 12th, 2011, 12:42 AM
Replies: 5
Views: 3,525
Posted By debasisdas
Please follow the syntax as i have shown in my...

Please follow the syntax as i have shown in my previous post.

Oracle 10g allows you to define your own string delimiters to remove the need to double up any single quotes. Any character that is...
Forum: Oracle April 12th, 2011, 12:33 AM
Replies: 5
Views: 3,782
Posted By debasisdas
The error is because you are trying to join 3...

The error is because you are trying to join 3 tables and the 3rd table is not joined to anything.

Post the table structures to get proper query.
Forum: Oracle April 8th, 2011, 06:43 AM
Replies: 5
Views: 3,782
Posted By debasisdas
Officially there is no term called IMPLICIT query...

Officially there is no term called IMPLICIT query or EXPLICIT query.

These terms are used for cursors not for query.

I think what you are trying to do is convert a query written in...
Forum: Oracle April 8th, 2011, 06:39 AM
Replies: 5
Views: 7,692
Posted By debasisdas
The keyword default means values (default values...

The keyword default means values (default values ) will be inserted into the specified column of the table if no data is passed in the insert statement (column is ignored). But if data is passed the...
Forum: Oracle April 8th, 2011, 06:28 AM
Replies: 5
Views: 3,525
Posted By debasisdas
You can also use the following . SELECT...

You can also use the following .

SELECT LENGTH(q''[This sentence's length will be calculated]'') "Length of characters"
FROM dual;

Can put any number of single quotes inside the square...
Forum: Oracle September 15th, 2010, 01:36 AM
Replies: 1
Views: 8,962
Posted By debasisdas
Check if the package is compiled without any...

Check if the package is compiled without any error and cross check if you have spelled the object name correctly.
Forum: SQL Language September 15th, 2010, 01:33 AM
Replies: 1
Views: 1,072
Posted By debasisdas
Do you have a question ?

Do you have a question ?
Forum: Oracle November 18th, 2009, 12:17 AM
Replies: 3
Views: 1,657
Posted By debasisdas
You have to create dblink to connect two...

You have to create dblink to connect two different databases.
Forum: Oracle August 6th, 2009, 10:02 AM
Replies: 2
Views: 1,042
Posted By debasisdas
If using 10 g better go for DBMS_SCHEDULER.

If using 10 g better go for DBMS_SCHEDULER.
Forum: Oracle March 5th, 2009, 05:19 AM
Replies: 2
Views: 1,042
Posted By debasisdas
That depends on how your servers are configured. ...

That depends on how your servers are configured.

You might need to do all that manually.
Forum: Pro VB Databases March 5th, 2009, 05:17 AM
Replies: 1
Views: 1,800
Posted By debasisdas
the following link might be useful to you. ...

the following link might be useful to you.

link (http://www.primaryobjects.com/CMS/Article59.aspx)
Forum: Beginning VB 6 March 5th, 2009, 05:13 AM
Replies: 2
Views: 1,005
Posted By debasisdas
you simply need to use a timer for the purpose. ...

you simply need to use a timer for the purpose.
set the interval as desired depending on the interval you want the code to re execute.
call the click event in the timer_timer event.
Forum: Oracle March 5th, 2009, 05:09 AM
Replies: 1
Views: 9,249
Posted By debasisdas
TRY THE FOLLOWING create database link...

TRY THE FOLLOWING


create database link DBL1 connect to otheruser identified by otherpassward using 'DBNAME'

create mytable as select * from othertable@dbl1;
Forum: Oracle March 5th, 2009, 05:05 AM
Replies: 1
Views: 873
Posted By debasisdas
the following is a simple solution. select...

the following is a simple solution.

select rownum from dba_tab_cols where rownum <=1000
minus
select code_num from table1
better to write a procedure for the purpose.
Forum: Beginning VB 6 March 5th, 2009, 04:55 AM
Replies: 2
Views: 2,133
Posted By debasisdas
you need to parse the date to proper format...

you need to parse the date to proper format before passing the same to the database for further processing.
Forum: VB Components March 5th, 2009, 04:49 AM
Replies: 2
Views: 12,529
Posted By debasisdas
have you connected the subreports as well to...

have you connected the subreports as well to database from application ?
Forum: Beginning VB 6 September 21st, 2008, 12:33 PM
Replies: 1
Views: 932
Posted By debasisdas
you can use join between both the tables using...

you can use join between both the tables using SQL for all that.

Regards
Debasis
Forum: Pro VB Databases September 21st, 2008, 12:30 PM
Replies: 2
Views: 5,799
Posted By debasisdas
i believe you are not using VB 6.0 Regards ...

i believe you are not using VB 6.0

Regards
Debasis
Forum: Pro VB Databases September 21st, 2008, 12:27 PM
Replies: 2
Views: 1,823
Posted By debasisdas
you want to load the entire database into memory...

you want to load the entire database into memory ? but that is not a fisible solution.

Regards
Debasis
Forum: Oracle July 4th, 2008, 04:43 AM
Replies: 4
Views: 6,509
Posted By debasisdas
taht is becauase the query framed by you at...

taht is becauase the query framed by you at runtime selects the text wrongly provided by you not the actual data from the desired columns. You need to reframe your queery properly at run time.
...
Forum: Oracle July 4th, 2008, 04:41 AM
Replies: 1
Views: 2,014
Posted By debasisdas
you need to reset the parameter for the database....

you need to reset the parameter for the database.

Regards
Debasis
Forum: Oracle July 4th, 2008, 04:38 AM
Replies: 1
Views: 965
Posted By debasisdas
you need to use COUNT with the username and...

you need to use COUNT with the username and corresponding password entered by the user to check for the existance of the same in the database. If count returns 1 allow to login else reprompt for the...
Forum: Oracle July 4th, 2008, 04:34 AM
Replies: 3
Views: 1,458
Posted By debasisdas
please find a related discussion at...

please find a related discussion at http://asktom.oracle.com/tkyte/Mutate/index.html
and
http://www.dba-oracle.com/t_avoiding_mutating_table_error.htm

Regards
Debasis
Forum: Oracle July 4th, 2008, 04:28 AM
Replies: 1
Views: 7,371
Posted By debasisdas
You need to convert the image file to a tream of...

You need to convert the image file to a tream of bytes ans store that in the BLOB field in database table. Need to go reverse way to retrive the image.

Regards
Debasis
Showing results 1 to 25 of 31

 


All times are GMT -4. The time now is 08:51 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.