By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

View the TAble datatypes,null and names in datagird

P: 5
Dear All

Can Anyone knows how to view the Name,Datatype and NUll of all tables created . , i use visual basic as front end and oracle as back end...

examples
EMP TABLE

Name DataTypes NULL?
-------------------------------------------------------------
Smith varchar2(20) NOT NULL





thank you very much

totz
Sep 3 '07 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
what do you mean by data type of tables ?
you can find out for fields not for a table.
Sep 3 '07 #2

P: 5
what do you mean by data type of tables ?
you can find out for fields not for a table.
Yes. the datatypes of table i want to call it in vb form.. in oracle can easily view the
datatype, only DESC EMP in vb i dunno how i can call it.. i want to view like this in vb form: in datagrid . is this possible to make?

SQL> desc emp
Name Null? Type
------------------------------- -------- ----------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
Sep 3 '07 #3

P: 5
Yes. the datatypes of table i want to call it in vb form.. in oracle can easily view the
datatype, only DESC EMP in vb i dunno how i can call it.. i want to view like this in vb form: in datagrid . is this possible to make?

example:
table= emp
field name=empno,ename,job,mgr,hiredate,sal,comm,deptno

in vb form i want to view this the fieldname datatypes.

SQL> desc emp
Name Null? Type
------------------------------- -------- ----------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

example:
table= emp
field name=empno,ename,job,mgr,hiredate,sal,comm,deptno

in vb form i want to view this the fieldname datatypes.

SQL> desc emp
Name Null? Type
------------------------------- -------- ----------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

thank you very much
Sep 3 '07 #4

P: 5
any one knows here knw how to use the ado schema
Sep 4 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.