What is the location of pre_defined_functions.
What is record in pl sql?
How do I write a sql query in pgadmin 4?
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
What is delimiter in pl sql?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is out parameter used for eventhough return statement can also be used in pl/sql?
How much does sql cost?
What are the benefits of pl/sql packages?
What is snowflake sql?
How long will it take to learn pl sql?
What is your daily office routine?