explain the advantages and disadvantages of stored procedure? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What is numeric function sql?
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
How is data stored in sql?
How do I run a sql query?
Why do you partition data?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
Do stored procedures prevent sql injection?
i want to display 1 to 10 numbers using one select statement.
18 Answers HCL, Nyros, Oracle,
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
What is dialect in sql?