User Profile

debasisdas · Apr 28 '14, 12:06 PM

Try using this.

Code:

CREATE TABLE EMP
(EMP_ID   NUMBER(10),
 ENTRY_DATE DATE DEFAULT SYSDATE NOT NULL,
 EMP_DOB  DATE,
CONSTRAINT EMP_DOB_NON_FUTURE CHECK (EMP_DOB <= ENTRY_DATE)
);

Following is the list of Restrictions on Check Constraints in Oracle:

You cannot specify a check constraint for a view. However, you can define the view using the WITH CHECK OPTION clause, which is...

debasisdas · Oct 15 '13, 10:45 AM

What exactly you are looking for ?

debasisdas · Sep 3 '13, 07:22 AM

make the control read only.

Both read only and multiline will be available in the property of the control.

debasisdas · Sep 3 '13, 07:17 AM

For that you need to understand Regular Expression.

debasisdas · Dec 28 '12, 10:56 AM

This is what you are looking for.

debasisdas · Dec 26 '12, 09:59 AM

I do not understand why dept_id refers eid

and by the way what is the data type of eid column in emp table ?

debasisdas · Dec 15 '12, 10:15 AM

If you do not know what is SQL Plus, please let me know where are you writing all your SQL queries .

debasisdas · Dec 15 '12, 10:00 AM

you need to implement the pattern matching in the search code using LIKE operator and call the same in the textbox_change( ) event.

for search code
1. connect to database.
2. open the record set.
3. then implement the search using dynamic SQL and display the result in some control like list box or grid.

debasisdas · Dec 13 '12, 09:29 AM

Yes, you can but there will be limitation on the number of concurrent connections.

debasisdas · Dec 10 '12, 09:17 AM

Do you have oracle installed on your system or only toad is installed. Those details are for the DB schema details that you want to connect through TOAD.

debasisdas · Dec 10 '12, 09:16 AM

You need to use the utilities EXP/EXPDP and IMP/IMPDP depending on the versions of the oracle that you are using.

debasisdas · Nov 2 '12, 08:45 AM

If you are looking for the connection string, please find it here.

debasisdas · Oct 17 '12, 10:29 AM

What is the source database that you are using ?

Some of the source data types may not be populated properly in an excel sheet.

By the way what is the code that you are working on ?

debasisdas · Oct 16 '12, 02:16 PM

try this

Code:

SELECT Contract_detail.Contract_no
FROM   Contract_detail INNER JOIN ContractRewriteHistory ON Contract_detail.Contract_no = ContractRewriteHistory.ContractNo
WHERE NOT EXISTS
(
SELECT ContractNo FROM ContractRewriteHistory WHERE 
ContractNo<>'' AND
ContractRewriteHistory.ContractNo = Contract_detail.Contract_no
);

debasisdas · Oct 16 '12, 02:07 PM

What about creating a view based on 3 source tables .

And for the 2nd part of your code just search here with proper key words. There are plenty of code available, as we have already discussed this several times here in the past.

debasisdas · Oct 8 '12, 11:35 AM

Would you mind explaining how are you trying to achieve the same. Lets see your code and fix it.

debasisdas · Oct 4 '12, 09:34 AM

What if there are no more projects in PHP after 6 months.

debasisdas · Sep 22 '12, 11:31 AM

It is here and here.

debasisdas · Aug 17 '12, 05:19 AM

As already suggested use single quotes on both the sides and trim the values before assigning to the variable if the variable is a string type. If it is a number type, you will not have any issue.

debasisdas · Jul 30 '12, 06:13 AM

Try to create a materialized view with BUILD IMMEDIATE by using the Underlying SQL.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment: