1
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 pointsBadges:
  • null v/s ” “(empty string) in Java

    what is the difference between null string and emty string(" " ) in java? String name; if(name == null || name == "") { } wat is the meaning of the abouve if statement?

    Prcvjr220 pointsBadges:
  • Constraints (MySql,tables,null,PK,FK etc)

    Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

    Ak1bo78150 pointsBadges:
  • Eliminating Nulls in tSQL

    If I want to return null values in a query that has "Where Field1<>'test' is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES ('test') INSERT INTO myTable VALUES('test2') INSERT INTO myTable VALUES(null) GO Select * From myTable...

    TJay85 pointsBadges:
  • empty fields in a query

    I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...

    Bananahead60 pointsBadges:
  • Null Expressions

    I am sure this is simple, I just need to know what the expressions is if you have fields in lets say a report that are : some empty and some with information...such as Telephone Field. I want to show only those "telephone" that are actually in the field. Example John Doe 555-555-5555 430 Cow Street...

    Karenfae30 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 pointsBadges:
  • Records with null value not in output

    See query: select distinct f2.description Business_Unit, f3.description Department, f4.description Function, a.segment5 Account, f5.description Account_Description, sum(nvl(d.entered_dr,0) - nvl(d.entered_cr,0)) Actual, (Select sum(nvl(dd.entered_dr,0) - nvl(dd.entered_cr,0)) from...

    Tams5 pointsBadges:
  • Excel 2003 Cell has formula but empty Value or text

    Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is empty...

    JonsIL45 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following