Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
- 0 Answers
- 537 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
Is a table valued function object?
Can a primary key be a foreign key?
What is sql in oracle?
What is the difference between Union and Union all. Which is faster.
What is trigger and types?
How do I copy a table in sql?
Which tcp/ip port does sql server run?
Can we join same table in sql?
write a query to find 4th max salary
what is 'mysqldump'? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
