I have a test_table with the following data : [code] select * from test_table; [/code] Number Name 1 AA 1 DD 2 QQ 3 WW 4 EE
Question
Oraask Latest Questions
Question
suppose I want to find all tables and views that has column name "last_name" for example.
Question
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true
Question
hello I want to know if my column value is number or character in oracle 10g something like : select (case when ( is_number(mycolumn)) then 'your column value is number' else 'your column value is not number'
Question
i have a table with some values in it basically i want to count how many number (2) present in this table : Col1 Col2 Col3 ----- ------- ------- 2 1 3 8 ...